Table
table 생성
create table tb_test(
col1 varchar2(10),
col2 varchar2(10),
col3 varchar2(10)
);
table 복제
create table tb_test03
as
select employee_id, first_name, salary
from employees;
create table tb_test04(empno, name, money)
as
select employee_id, first_name, salary
from employees
where 1 = 2;
create table tb_test04
as
select *
from employees
where 1 = 2;
table 수정
alter table tb_test04
rename to tb_test99;
alter table tb_test99
add deptname number(3);
alter table tb_test99
modify deptname varchar2(20);
alter table tb_test99
drop column deptname;