/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 vote322 views1 answer
Database get 10 user aleatory
SQL
1 vote341 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote338 views1 answer
Count number of entires by months sql
SQL
0 vote345 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote314 views1 answer
Print orcale
SQL
2 votes325 views1 answer
Oracle sql day of month from date
SQL
0 vote313 views1 answer
Mysql_error replacement
SQL
1 vote285 views1 answer
Insert into sql
SQL
1 vote335 views1 answer
Postgresql pass array in function
SQL
5 votes338 views2 answers
Postgres update with if condition query
SQL