/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 votes202 views1 answer
How to search table name in stored procedure in sql server
SQL
18 votes203 views6 answers
Create table mysql
SQL
1 vote192 views1 answer
Psql datetime grather than
SQL
1 vote251 views1 answer
Oracle drop chain step
SQL
1 vote216 views1 answer
How to fetch alternate records from two tables
SQL
7 votes201 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote214 views1 answer
Postgres grep entire database
SQL
0 vote224 views1 answer
Postgresql custom order by
SQL
6 votes231 views2 answers
Clear a table in mysql
SQL
0 vote222 views1 answer
Oracle show grants on table
SQL