/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

36 votes230 views6 answers
Change column data type sql
SQL
0 vote99 views1 answer
Postgresql stored procedure update table values
SQL
0 vote62 views1 answer
Postgres delete where id in
SQL
0 vote107 views1 answer
Plsql check for string in numeric
SQL
0 vote131 views1 answer
Reset a table's identity column and remove test records
SQL
3 votes108 views2 answers
Sql select data from last week
SQL
0 vote105 views1 answer
Sql delete from with relation
SQL
0 vote133 views1 answer
How to change the field size of an existing column
SQL
1 vote116 views1 answer
Snowflake rename column name
SQL
1 vote101 views2 answers
How to check username in mysql command line
SQL