O'Reilly logo

Database Systems by Shripad V. Godbole, Elvis C. Foster

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 12

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required