/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 vote276 views2 answers
Sql server select where date
SQL
0 vote299 views1 answer
Mysql equivalent decode oracle
SQL
1 vote296 views1 answer
Quit mysql
SQL
-1 vote275 views1 answer
Mysql extract days
SQL
2 votes295 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote279 views1 answer
Regex mongoose
SQL
17 votes282 views6 answers
Get last record in sql
SQL
3 votes292 views1 answer
Query less than datetime sql
SQL
0 vote284 views1 answer
Mysql count grouped rows
SQL
0 vote281 views1 answer
Show size of all tables postgres
SQL