/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 vote333 views1 answer
Mysql milliseconds
SQL
0 vote361 views1 answer
Oracle list datafiles
SQL
0 vote338 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote322 views2 answers
Return the number of records in a single table mysql
SQL
5 votes348 views3 answers
Db begintransaction laravel
SQL
1 vote339 views2 answers
Sql for date greater than
SQL
2 votes326 views1 answer
Merge two columns in sql oracle
SQL
2 votes357 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
16 votes320 views3 answers
Order by sql query
SQL
0 vote338 views1 answer
Postgres type equivalent to timespan c#
SQL