/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

1 vote148 views1 answer
Get create table query existing table mysql
SQL
0 vote110 views1 answer
Mysql offset from bottom
SQL
0 vote141 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote140 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote154 views1 answer
Update sqlite
SQL
0 vote140 views1 answer
Select last 2 characters sql
SQL
0 vote169 views1 answer
Set classpath for mysql-connector.jar
SQL
1 vote143 views1 answer
SQL query to get all table records count from a database
SQL
0 vote156 views1 answer
Least spark sql
SQL
1 vote174 views1 answer
Sql query row number group by
SQL