CREATE TABLE temp AS SELECT * FROM distributors;
DROP TABLE distributors;
CREATE TABLE distributors AS SELECT * FROM temp;
DROP TABLE temp;
DROP TABLE distributors;
CREATE TABLE distributors AS SELECT * FROM temp;
DROP TABLE temp;
CREATE TABLE temp AS SELECT * FROM distributors;
DELETE distributors;
ALTER TABLE distributors ADD COLUMN address VARCHAR2(30);
ALTER TABLE table DROP [ COLUMN ] column
CREATE TABLE distributors AS SELECT * FROM temp;
DROP TABLE temp;
/
insert all
into test(col)
into test(col)
into test(col)
into test(col)
select 'a' from dual
/
select * from test
/
create table temp as select * from test
/
truncate table test
/
alter table test modify (col varchar2(20))
/
insert into test select * from temp
/
drop table temp
/
select * from test
/
desc test
/
drop table test
/