/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 vote148 views2 answers
Update information in a mysql column
SQL
5 votes150 views1 answer
Oracle ora-00054 causes
SQL
4 votes160 views1 answer
Oracle show errors
SQL
0 vote163 views1 answer
Date on SQL
SQL
0 vote139 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote171 views1 answer
Replace divide by zero error with 0 in sql
SQL
2 votes146 views4 answers
Duplicate record mysql
SQL
13 votes147 views2 answers
Check if value is null mysql
SQL
0 vote136 views2 answers
Influxdb delete measurement based on date
SQL
3 votes108 views4 answers
Show columns from table
SQL