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';Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
