/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

0 vote122 views1 answer
Mysql multiple group by
SQL
1 vote132 views3 answers
Drop unique key constraint in sql server
SQL
0 vote119 views1 answer
Update top 100 sql
SQL
13 votes120 views6 answers
Restart postgresql
SQL
8 votes128 views1 answer
Sql remove leading spaces
SQL
0 vote143 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote142 views1 answer
Excel vba import data to sql server
SQL
1 vote121 views1 answer
Mysql history command
SQL
5 votes288 views2 answers
How to ascending order in sql
SQL
0 vote211 views1 answer
Install ms sql server management studio
SQL