/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

0 vote207 views1 answer
Oracle list partitions
SQL
1 vote213 views1 answer
Load mysql dumb
SQL
1 vote208 views1 answer
Oracle turn off constraint
SQL
0 vote214 views1 answer
Postegresql update to null
SQL
1 vote206 views2 answers
Mysql switch case
SQL
0 vote250 views1 answer
Get foreign table names mysql
SQL
0 vote196 views1 answer
Firebird where
SQL
0 vote202 views1 answer
Logtash mysql cofiguration file
SQL
1 vote206 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote204 views1 answer
How to remove default in mysql
SQL