/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 vote232 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
2 votes204 views1 answer
Mysql sysdate - 1 day
SQL
18 votes165 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote278 views1 answer
Python get backup of sql
SQL
0 vote206 views1 answer
Sql server query database space available
SQL
0 vote197 views1 answer
TSQL function split string
SQL
0 vote209 views1 answer
Csv to sqlite python
SQL
0 vote212 views1 answer
What is top n result in sql
SQL
1 vote213 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote212 views1 answer
Create tables from xsd to sql server database c#
SQL