Database Systems

CHAPTER 12

SQL Data Manipulation Statements

There are four core DML statements in SQL, namely INSERT, UPDATE, DELETE, and SELECT. These statements apply to base tables and views (views will be discussed in the next chapter). The chapter proceeds under the following subheadings:

• Insertion of Data
• Update Operations
• Deletion of Data
• Commit and Rollback Operations
• Basic Syntax for Queries
• Simple Queries
• Queries Involving Multiple Tables
• Queries Involving the Use of Functions
• Queries Using LIKE, BETWEEN and IN Operators
• Nested Queries
• Queries Involving Set Operators
• Queries With Runtime Variables
• Queries Involving SQL Plus Format Commands
• Embedded ...