/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 vote369 views1 answer
Mysql error 1452
SQL
3 votes349 views2 answers
Truncate all tables
SQL
2 votes411 views1 answer
Remove foreign key constraints in postgres
SQL
0 vote340 views1 answer
Nth max in my sql
SQL
22 votes343 views3 answers
Sql cheat sheet
SQL
12 votes355 views4 answers
Mysql get date difference in hours
SQL
0 vote413 views1 answer
Postgresql alter table sequence
SQL
0 vote334 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
8 votes339 views1 answer
Mysql restore database
SQL
0 vote364 views1 answer
Alter rename command in mysql
SQL