CHAPTER 4

image

Single Row Processing

Now you’ll begin your journey of using SQL in PL/SQL. You’ll start out slowly, inserting one row at a time, then updating one row at a time, then deleting one row at a time, and finally selecting one row at a time. I take this approach because you first have to insert data into a database before you can update, delete, or select it. I call these kinds of SQL statements singletons because they return one row of results. So let’s get started by putting some data into the database.

Inserts

The context here is inserting data into a relational database. To insert data into a relational database from PL/SQL, you simply ...

Get Beginning Oracle PL/SQL, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.