/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 vote194 views1 answer
Show function mysql
SQL
0 vote200 views1 answer
Plpgsql raise notice
SQL
0 vote225 views1 answer
Allow null in psql
SQL
2 votes196 views1 answer
Oracle sql day of month from date
SQL
0 vote207 views1 answer
Window function to forward fill
SQL
13 votes197 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote241 views1 answer
Plsql check how much space all databases are consuming
SQL
3 votes217 views1 answer
Oracle undo tablespace schema
SQL
1 vote207 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
4 votes161 views2 answers
Select todays data postgres query
SQL