/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

31 votes309 views4 answers
Mysql grant execute
SQL
2 votes298 views1 answer
Oracle drop sequence if exists
SQL
0 vote309 views1 answer
How to print some string in mysql
SQL
0 vote298 views1 answer
Window function to forward fill
SQL
0 vote321 views1 answer
Sql: extract day text from datetime value
SQL
0 vote294 views1 answer
Oracle sql log to console
SQL
10 votes298 views1 answer
User_dependencies
SQL
0 vote305 views1 answer
Sql reverse order of results
SQL
0 vote308 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote294 views2 answers
How to know the character set of an oracle databes
SQL