Answers for "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';

create-toys-table-with-toy_name-column

drop table toys;
create table toys (
  toy_id            integer,
  toy_name          varchar2(100),
  cuddliness_factor integer
);

alter table toys add ( weight number(10,1) );

alter table toys drop ( cuddliness_factor );

select column_name, data_type, data_length, data_precision, data_scale
from   user_tab_columns
where  table_name = 'TOYS';

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';