/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 vote126 views1 answer
Oracle start job
SQL
0 vote144 views1 answer
Except in sql alchemy
SQL
0 vote125 views1 answer
Order by ip address sql
SQL
6 votes137 views5 answers
Sql add months to date
SQL
4 votes125 views1 answer
Id primary key auto generated
SQL
3 votes141 views2 answers
Postgres alter table owner
SQL
0 vote133 views1 answer
Mysql join same table multiple times group by
SQL
0 vote188 views1 answer
Run docker container with database as rds metabase
SQL
5 votes125 views2 answers
Sql number columns
SQL
5 votes117 views2 answers
Oracle list columns schema
SQL