/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 vote110 views1 answer
Find difference in dates sql
SQL
2 votes114 views2 answers
Spring import sql
SQL
0 vote138 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
7 votes108 views3 answers
Foreign key oracle
SQL
3 votes127 views2 answers
How to open postgresql in windows
SQL
0 vote139 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote118 views1 answer
Mysql workbench indent formatting
SQL
5 votes116 views3 answers
Truncate function in sql oracle
SQL
1 vote133 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
1 vote117 views1 answer
Insert column after column mysql
SQL