UPDATE, INSERT, UPDATE문

 UPDATE

UPDATE table

SET       column = value [, column = value, ...][WHERE condition];


예) UPDATE employees     SET       department_id = 70     WHERE   employee_id = 113;

WHERE 절을 생략하면 데이틀의 모든 행이 수정된다.예) UPDATE copy_emp     SET       department_id = 110;서브쿼리를 이용한 UPDATE

UPDATE copy_emp
SET       department_id = (SELECT department_id   
                                  FROM     employees                                     
                                  WHERE   employee_id = 100)WHERE   job_id   
                                =(SELECT  job_id
                                     FROM     employees 
                                    WHERE    employee_id =200)



- INSERT

--컬럼명을 명시 해주는 것을 추천 (2)

1) INSERT INTO USERS

VALUES (USERS_SEQ.NEXTVAL,'GUEST','1234','손님','11111111111','서울역');

2) INSERT INTO USERS(USERSNO,EMAIL,PWD,NAME,PNO)

VALUES (USER_SEQ.NEXTVAL,'GUEST2','1234','손님2','11111111111');

- DELETE

1) DELETE FROM USERS

WHERE EMAIL='GUEST3';