Database Reference
In-Depth Information
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 SQL
•
Dynamic Queries
•
Summary and Concluding Remarks
The chapter will continue to use examples based on the college database described
in Chapter 7, so feel free to take some time to review this.