Oracle - wasurenaitame @ ウィキ

SQL文 書き方メモ

Insert Select

insert into emp (dept_name, dept_etc)
select dp.dept_name, dp.dept_etc
from dept dp

Insert

insert into emp (dept_name, dept_etc)
values ('aaa','bbb')

Update Select

update emp ep
 set (dept_name, dept_etc) = (
　　select dp.dept_name, dp.dept_etc
　　from dept dp
　　where　ep.dept_id = dp.dept_id )

Update

update 　emp 
 set  dept_name = 'aaa'
    , dept_etc  ='bbb'

Delete

 delete from emp