Oracle9i-SQL-20 Oracle9i Extensions to DML and DDL Statements oracle9i-sql-I sql语言大全.pdf

Oracle9i Extensions to DML and DDL Statements 20 Copyright © Oracle Corporation, 2001. All rights reserved. Objectives After completing this lesson, you should be able to do the following: • Describe the features of multitable inserts • Use the following types of multitable inserts – Unconditional INSERT – Pivoting INSERT – Conditional ALL INSERT – Conditional FIRST INSERT • Create and use external tables • Name the index at the time of creating a primary key constraint 20-2 Copyright © Oracle Corporation, 2001. All rights reserved. Review of the INSERT Statement • Add new rows to a table by using the INSERT statement. INSERT INTO table [(column [, column...])] INSERT INTO table [(column [, column...])] VALUES (value [, value...]); VALUES (value [, value...]); • Only one row is inserted at a time with this syntax. INSERT INTO departments(department_id, department_name, manager_id, location_id) VALUES (70, Public Relations, 100, 1700); 1 row created. 20-3 Copyright © Oracle Corporation, 2001. All rights reserved. Review of the UPDATE Statement • Modify existing rows with the UPDATE statement. UPDATE table UPDATE table SET column = value [, column = value, ...] SET column = value [, column = value, ...] [WHERE condition]; [WHERE condition]; • Update more than one row at a time, if required. • Specific row or rows are modified if you specify the WHERE clause. UPDATE employees SET department