오라클 insert select,update select (오라클 서브쿼리 추가)
1. insert select insert into users(USERNO,EMAIL,PWD,NAME,PNO,ADDRESS)(select '3' ,EMAIL,PWD,'TEST',PNO,ADDRESS from userswhere userno=2) 2. update select update usersset NAME=(Select name from users where userno='5')where userno='3'
더보기