/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 vote193 views1 answer
Primary key multiple
SQL
0 vote207 views1 answer
MySql get primary keys of table
SQL
0 vote181 views1 answer
Luu ckeditor vao mysql
SQL
0 vote190 views1 answer
Sql remove last 2 digit
SQL
12 votes195 views4 answers
Mysql version
SQL
0 vote195 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote198 views1 answer
Mysql get last 2 month data
SQL
0 vote197 views1 answer
Install package for sqlserver in asp.net core
SQL
2 votes193 views1 answer
Oracle to_char number format percentage
SQL
3 votes245 views2 answers
Brew restart mysql
SQL