/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 vote335 views1 answer
Sql delete row with auto increment
SQL
0 vote362 views1 answer
Mysql get hour from datetime
SQL
0 vote335 views2 answers
How to get json data mysql
SQL
18 votes326 views3 answers
Mysql number format
SQL
0 vote332 views1 answer
Convert .mdf to .bak
SQL
0 vote330 views1 answer
Connect postgresql using a connection string
SQL
0 vote397 views1 answer
Mssql last day of month
SQL
2 votes323 views5 answers
Alter table primary key postgresql
SQL
0 vote337 views1 answer
Cast for print sql
SQL
1 vote321 views2 answers
Pl sql case
SQL