1. update 쿼리
SQL> update employees
2 set salary = salary * 1.15
3 where job_id ='IT_PROG';
2 set salary = salary * 1.15
3 where job_id ='IT_PROG';
3 rows updated.
2. delete 쿼리
SQL> delete from emp2
2 where employee_id = 0;
2 where employee_id = 0;
1 row deleted.
3. 테이블의 모든 내용 삭제 할때
delete from emp2;
21 rows deleted.
혹은
SQL> truncate table emp2;
Table truncated.