/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 vote163 views1 answer
Mysql remove last empty newline
SQL
3 votes169 views1 answer
Force using index plsql
SQL
0 vote183 views1 answer
Datatables server side filter where clause
SQL
0 vote137 views1 answer
Query for maximum salary
SQL
2 votes185 views1 answer
How to get weekday from old date in sql
SQL
1 vote188 views1 answer
Check current sequence value postgres
SQL
0 vote218 views1 answer
Reset a table's identity column and remove test records
SQL
2 votes159 views2 answers
Mysql all columns
SQL
2 votes174 views1 answer
Wait delay in sql server
SQL
0 vote181 views1 answer
Postgresql replace html tags from string
SQL