/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

4 votes158 views1 answer
Mysql insert from local csv
SQL
0 vote168 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
14 votes166 views2 answers
Oracle add column with default value
SQL
0 vote192 views1 answer
View to table
SQL
9 votes182 views6 answers
Sql add column with default value
SQL
0 vote230 views1 answer
Oracle plsql sleep
SQL
1 vote128 views1 answer
Ms sql how to see active job current run time
SQL
20 votes169 views5 answers
Mysql reset auto increment to 1
SQL
1 vote161 views1 answer
Sql select all from one table and one column from another
SQL
5 votes180 views1 answer
Oracle drop index if exists
SQL