/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 vote201 views1 answer
Find how many tables in database sql query
SQL
0 vote199 views1 answer
Duplix print in Smartforms
SQL
0 vote285 views1 answer
Site:av.ru "files"
SQL
0 vote203 views1 answer
Stratified sampling sql
SQL
0 vote182 views1 answer
New rails app with mysql
SQL
0 vote184 views1 answer
Selecting duplicates
SQL
6 votes278 views1 answer
Check Table Exists
SQL
4 votes175 views1 answer
Sql query to make a existing column auto increment
SQL
2 votes179 views2 answers
Created at and updated at in mysql
SQL
2 votes192 views1 answer
Where clause for child record apex
SQL