SQL 基本(select以外)

create table TEST_TABLE(val1 number,val2 varchar(10)var3 date)
drop table TEST_TABLE

insert into TEST_TABLE(val1,val2) values(10,’val2′)
insert into TEST_TABLE values(10,’val2′,sysdate)

update TEST_TABLE set val2=’updated’,val3=sysdate where val1=10

delete from TEST_TABLE where val1=10

delte from TEST_TABLE where (val1,val2,val3…)IN
( select val1,val2,val3…
from …
)

alter table TEST_TABLE add(val4 number)
alter table TEST_TABLE modify(val4 date)
alter table TEST_TABLE drop(val4)
alter table TEST_TABLE RENAME COLUMN val3 to day

alter table TEST_TABLE add primary key (
val1,
val2,
val3,

)