오라클 insert select,update select (오라클 서브쿼리 추가)

1. insert select

insert into users(USERNO,EMAIL,PWD,NAME,PNO,ADDRESS)

(

select '3' ,EMAIL,PWD,'TEST',PNO,ADDRESS from users

where userno=2

)

2. update select

update users

set NAME=(Select name from users where userno='5')

where userno='3'