[Oracle] INSERT, UPDATE, DELETE

[Oracle] INSERT, UPDATE, DELETE

INSERT : TABLE ROW 추가

INSERT INTO Table_name(column1, column2,...) VALUES(value1, value2,...);

Ex)

INSERT INTO USERINFO(NAME, ADDRESS) VALUES('홍길동', '제주도 한라산');

UPDATE : TABLE ROW 수정

UPDATE Table_name SET column1 = value1, column2 = value2 WHERE 조건;

Ex)

UPDATE USERINFO SET ADDRESS = '강원도 설악산' WHERE NAME = '홍길동';

DELETE : TABLE ROW 삭제

DELETE FROM Table_name WHERE 조건;

Ex)

DELETE FROM USERINFO WHERE NAME = '홍길동' AND ADDRESS = '강원도 설악산';