/SQL/Create-toys-table-with-toy_name-column

Create-toys-table-with-toy_name-column

create table bricks (
  brick_id nunber(20,0),
  colour varchar2(10),
  price number(10,2),
  purchased_date date
);

select column_name, data_type, data_length, data_precision, data_scale
from   user_tab_columns
where  table_name = 'BRICKS';

Source: livesql.oracle.com

Create-toys-table-with-toy_name-column

create table toys (
  toy_name varchar2(10)
);

select column_name, data_type, data_length
from   user_tab_columns
where  table_name = 'TOYS';

Source: livesql.oracle.com

Similar codes

4 votes258 views1 answer
Oracle session date format
SQL
7 votes267 views4 answers
What is my mysql version
SQL
0 vote257 views1 answer
Oracle to_number
SQL
1 vote260 views3 answers
How to get date in sql
SQL
1 vote234 views1 answer
Mysql date diff in seconds
SQL
0 vote251 views2 answers
How to start postgresql laravel
SQL
0 vote264 views1 answer
How to reset the database value in SQL server
SQL
2 votes242 views1 answer
Date_format for time sql
SQL
0 vote243 views1 answer
Time mysql w3
SQL
11 votes248 views2 answers
MySQL DISTINCT
SQL