/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 votes181 views3 answers
Mysql cheat sheet
SQL
0 vote135 views2 answers
Mysql update two tables at once
SQL
11 votes131 views1 answer
Get ddl materialized view oracle
SQL
20 votes146 views6 answers
Creating a table in sql
SQL
0 vote135 views1 answer
Pl sql disable trigger
SQL
1 vote128 views2 answers
Drop function in sql
SQL
5 votes154 views6 answers
Sql foreign key
SQL
0 vote142 views1 answer
Mysql get last 2 month data
SQL
3 votes127 views1 answer
Oracle APEX elapsed time
SQL
0 vote148 views1 answer
Get last updated row sql server
SQL