/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

1 vote138 views1 answer
Create procedure with encryption
SQL
35 votes165 views5 answers
Sql alter column
SQL
0 vote143 views1 answer
Sql server change schema of a table
SQL
0 vote149 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
1 vote141 views1 answer
Postgresql reset serial counter after deleting content
SQL
1 vote156 views1 answer
Add current timestamp in mysql
SQL
0 vote141 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote143 views1 answer
Sql row number in result set
SQL
0 vote142 views1 answer
Sql server select record with max id
SQL
0 vote144 views1 answer
Cast as decimal postgresql
SQL