/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 vote341 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote294 views1 answer
Oracle execute immediate quotes
SQL
5 votes322 views4 answers
Select random rows sql
SQL
1 vote310 views1 answer
Mysql batch insert
SQL
0 vote316 views1 answer
How to drop a trigger in postgresql
SQL
0 vote327 views1 answer
Resullt all update knex mysql
SQL
0 vote322 views1 answer
Sqlalchemy get schema from database
SQL
6 votes322 views1 answer
Oracle list primary key
SQL
0 vote312 views1 answer
Increase speed of like queries postgres
SQL
1 vote339 views1 answer
Psql filed name alter
SQL