/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 vote375 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote362 views1 answer
How to declare variable date in mysql
SQL
1 vote358 views2 answers
Sql queries practice
SQL
36 votes369 views6 answers
Rename table sql
SQL
0 vote356 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote337 views1 answer
Default password for mysql_secure_installation in mac
SQL
2 votes405 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote370 views1 answer
Mysql remove bad character from all fields
SQL
0 vote352 views4 answers
Mysql count table rows
SQL
0 vote345 views1 answer
Mysql join same table multiple times group by
SQL