/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

7 votes254 views6 answers
Mysql group concat
SQL
0 vote283 views1 answer
Mysql, how to query the table comments?
SQL
2 votes229 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
1 vote226 views1 answer
Alter add syntax
SQL
4 votes238 views2 answers
Oracle drop job
SQL
0 vote216 views1 answer
Find largest table in mysql database
SQL
2 votes225 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote231 views1 answer
Sql select duplicates based on two columns
SQL
4 votes219 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote220 views2 answers
How to find max and min salary in sql
SQL