/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

1 vote277 views3 answers
Get all tables postgres
SQL
1 vote279 views1 answer
Sql where max date
SQL
1 vote259 views1 answer
Postgres get month name from date
SQL
0 vote256 views1 answer
Sql select first and last record of each group
SQL
0 vote255 views2 answers
Mysql select date from datetime
SQL
2 votes270 views1 answer
Mysql create user with mysql_native_password
SQL
2 votes283 views1 answer
Mysql create user with remote access
SQL
0 vote266 views1 answer
Match end of string regex sql
SQL
0 vote227 views1 answer
FindAllBy
SQL
25 votes293 views1 answer
How to update an attribute in MySQL
SQL