/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 vote186 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
1 vote208 views1 answer
Sql server kill all connections
SQL
0 vote200 views1 answer
Bitmap join index
SQL
14 votes200 views4 answers
Import database through command line
SQL
2 votes183 views1 answer
Sql to char function with date
SQL
6 votes180 views1 answer
Oracle trigger after logon on database
SQL
0 vote218 views1 answer
Comma seperated join mssql
SQL
33 votes177 views2 answers
Postgres how to add field created at
SQL
0 vote282 views1 answer
Show mysql account privilleges
SQL
1 vote196 views1 answer
Clear screen command in psql
SQL