/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 vote392 views1 answer
For select oracle
SQL
0 vote373 views1 answer
How to update sql server version
SQL
0 vote400 views1 answer
Sql constarint
SQL
2 votes398 views1 answer
Oracle Column Names of a table
SQL
0 vote364 views1 answer
Max mysql
SQL
1 vote351 views1 answer
Importance of comment in mysql
SQL
6 votes351 views1 answer
Oracle rank() over (partition)
SQL
1 vote355 views1 answer
Mysql show long running queries
SQL
0 vote369 views1 answer
Postgresql get diff between two dates in Months
SQL
3 votes341 views1 answer
Sql cast to integer
SQL