Oracle数据库数据增删改查实战技巧.pptVIP

oracle操作数据DML语句;目标;;

;INSERTINTO table[(column[,column...])]

VALUES (value[,value...]);;;

;

;

;

;

;INSERTINTO

(SELECTemployee_id,last_name,

email,hire_date,job_id,salary,

department_id

FROMemployees

WHEREdepartment_id=50)

VALUES(99999,Taylor,DTAYLOR,

TO_DATE(07-7月-99,DD-MON-RR),

ST_CLERK,5000,50);

1rowcreated.;

;UPDATE table

SET column=value[,column=value,...]

[WHERE condition];;;

;SQL UPDATE employee

2 SET deptno=(SELECT deptno

3 FROM emp

4 WHERE empno=7788)