oracle操作数据DML语句.pptxVIP

  • 1
  • 0
  • 约2.23千字
  • 约 36页
  • 2021-06-16 发布于河北
  • 举报
八.操作数据-DML语句;目标;; ;INSERT INTO table [(column [, column...])] VALUES (value [, value...]);;; ; ; ; ; ;INSERT INTO (SELECT employee_id, last_name, email, hire_date, job_id, salary, department_id FROM employees WHERE department_id = 50) VALUES (99999, Taylor, DTAYLOR, TO_DATE(07-7月-99, DD-MON-RR), ST_CLERK, 5000, 50); 1 row created.; ;UPDATE table SET column = value [, column = value, ...] [WHERE condition];;; ;SQL UPDATE employee 2 SET deptno = (SELECT deptno 3 FROM emp 4 WHERE empno = 7788) 5 W

文档评论(0)

1亿VIP精品文档

相关文档