/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

7 votes191 views3 answers
Sql set
SQL
2 votes226 views1 answer
Postgresql transaction
SQL
0 vote186 views1 answer
Set default value now() date
SQL
8 votes233 views1 answer
Mac restore mysql database command line
SQL
0 vote201 views2 answers
Nodejs mysql convert to plain object
SQL
1 vote192 views1 answer
Search for tables with name postgresql
SQL
0 vote184 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote189 views1 answer
Oracle calculate statistics on partition
SQL
2 votes225 views1 answer
Datefromparts mssql
SQL
0 vote205 views1 answer
Make parameters nullable in sql server
SQL