/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 vote107 views1 answer
How many columns can be used for creating index?
SQL
1 vote91 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote130 views1 answer
Cube oracle
SQL
0 vote119 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote111 views1 answer
Mysql to get column name in database
SQL
2 votes116 views2 answers
Postgres add column integer
SQL
0 vote116 views1 answer
Ver usuarios mysql
SQL
5 votes102 views2 answers
Oracle timestamp to date
SQL
1 vote98 views4 answers
Between vs in sql
SQL
0 vote101 views1 answer
Convert rows to columns in sql server
SQL