/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

8 votes193 views3 answers
Postgres database sizes
SQL
1 vote187 views2 answers
Sql where is not number
SQL
0 vote189 views2 answers
Suse stop MySQL
SQL
0 vote180 views1 answer
Install sql server windows 10
SQL
1 vote198 views1 answer
Store select query result in variable sql server
SQL
5 votes164 views1 answer
Update sql user password
SQL
0 vote176 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote193 views1 answer
Start stop mysql linux
SQL
0 vote168 views1 answer
Sql server cannot create database diagram
SQL
8 votes197 views3 answers
Connect python to mysql
SQL