/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 vote288 views1 answer
Materialized view redshift
SQL
0 vote266 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
1 vote278 views1 answer
Mysql decimal allow negative values?
SQL
0 vote226 views2 answers
Delete the last item in a table sql
SQL
0 vote272 views1 answer
Mysql could not fetch tables
SQL
3 votes268 views1 answer
Sql server check version
SQL
45 votes342 views5 answers
Grant all privileges mysql
SQL
0 vote285 views1 answer
Change database name psql 8
SQL
8 votes274 views1 answer
Show mysql user table
SQL
0 vote271 views1 answer
Sql change date format
SQL