TAILIEUCHUNG - Oracle9i Extensions to DML and DDL Statements

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 | Oracle9i Extensions to DML and DDL Statements Schedule: Timing Topic 40 minutes Lecture 30 minutes Practice 70 minutes Total 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 Lesson Aim This lesson addresses the Oracle9i extensions to DDL and DML statements. It focuses on multitable INSERT statements, types of multitable INSERT statements, external tables, and the provision to name the index at the time of creating a primary key constraint. Review of the INSERT Statement Add new rows to a table by using the INSERT statement. Only one row is inserted at a time with this syntax. INSERT INTO table [(column [, column.])] VALUES (value [, value.]); INSERT INTO departments(department_id, department_name, manager_id, location_id) VALUES (70, 'Public Relations', 100, 1700); 1 row created. Review of the INSERT Statement You can add new rows to a table by issuing the INSERT statement. In the syntax: table is the name of the table column is the name of the column in the table to populate value is the corresponding value for the column Note: This statement with the VALUES clause adds only one row at a time to a table. Instructor Note You can skip this slide if the students are already familiar with these concepts. Review of the UPDATE Statement Modify existing rows with the UPDATE statement. Update more than one row at a time, if required. Specific row or rows are modified if you specify the WHERE clause. UPDATE table SET column = value [, column = value, .] [WHERE condition]; UPDATE employees SET department_id = 70 WHERE employee_id = 142; 1 row updated. Review of the UPDATE Statement You can modify existing rows by using the UPDATE statement. In the syntax: table is

• Cơ sở dữ liệu
• Oracle XML Applications
• database
• data management
• Oracle XML
• Performance Tuning
• XML Data
• Administration
• Oracle Blocks Efficiently
• Oracle Data Storage Structures
• Oracle Enterprise Manager
• EXPORT IN ORACLE
• Oracle Server
• Managing an Oracle Instance
• Tuning the Oracle Shared Server
• Oracle Architectural Components
• System APIs
• Oracle Workflow
• Data Dictionary
• Managing Undo Data
• SQL Statement Tuning
• Creating Views
• Oracle9i Datetime Functions
• Managing Privileges
• Managing RolesRoles
• Advanced Subqueries
• Using Resource Manager
• Auditing
• Hierarchical Retrieval