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';
3.67
9
create table toys (
toy_name varchar2(10)
);
select column_name, data_type, data_length
from user_tab_columns
where table_name = 'TOYS';
Thank you!
9
0
4.2
4
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';
Thank you!
4
0
Are there any code examples left?
New code examples in category SQL