/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 vote168 views1 answer
Psql select * from table
SQL
0 vote194 views1 answer
Data types mysql vs postgresql
SQL
5 votes183 views1 answer
Sql use database
SQL
5 votes160 views2 answers
Add column postgres with default value
SQL
0 vote203 views1 answer
Get relation data in mysql using query to excel
SQL
1 vote172 views1 answer
Access the postgres psql
SQL
0 vote184 views2 answers
Advantages of stored procedures sql
SQL
7 votes183 views3 answers
Sql server reset auto increment
SQL
1 vote160 views1 answer
PLS-00225 type
SQL
0 vote175 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL