/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 vote230 views1 answer
Oracle sql all days except weekends
SQL
1 vote230 views1 answer
Convert epoch to date in sql server
SQL
4 votes205 views2 answers
Select first and last row mysql
SQL
-1 vote243 views1 answer
How to Activate the database
SQL
0 vote226 views1 answer
Sql delete row from table where id
SQL
2 votes263 views1 answer
Python sql
SQL
0 vote217 views1 answer
Mysql undo delete
SQL
0 vote223 views1 answer
Mysql dump everythign
SQL
4 votes348 views6 answers
Laravel jwt
SQL
0 vote228 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL