/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 vote269 views2 answers
Sql split string by space
SQL
2 votes235 views1 answer
Query any digits record
SQL
0 vote233 views1 answer
Drop all procedures sql server
SQL
1 vote253 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
6 votes257 views3 answers
Create database mysql utf8
SQL
0 vote264 views1 answer
Sql to excel pgadmin
SQL
0 vote245 views1 answer
Second Step in installing SQL workbench
SQL
12 votes237 views5 answers
Sql merge
SQL
4 votes251 views2 answers
Installing sql on ubuntu
SQL
3 votes241 views3 answers
C# sql select
SQL