/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

2 votes127 views2 answers
Mysql limit
SQL
0 vote116 views1 answer
Sql select rows with different values in one column
SQL
0 vote113 views1 answer
How to move a columns location in mysql
SQL
0 vote126 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote117 views1 answer
Sql count * vs count 1
SQL
0 vote144 views1 answer
Sp help text in postgresql
SQL
0 vote118 views1 answer
Apache Derby: Create SQL Dump with data
SQL
12 votes113 views4 answers
Mysql ifnull
SQL
1 vote115 views1 answer
Crontab every month
SQL
25 votes140 views1 answer
How to update an attribute in MySQL
SQL