/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 vote210 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote204 views1 answer
Object of class mysqli_result could not be converted to string
SQL
3 votes208 views2 answers
Brew restart mysql
SQL
0 vote200 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote181 views2 answers
Sql query unique
SQL
3 votes203 views2 answers
Postgres download
SQL
20 votes187 views2 answers
Counting in sql
SQL
2 votes199 views2 answers
Sql query to list all tables in a database sql server
SQL
6 votes200 views3 answers
Date_trunc postgres
SQL
0 vote204 views1 answer
Typeorm raw sql
SQL