CHAPTER 4Whoa! One Statementat a Time, Please!

Now we begin our journey of using SQL in PL/SQL. We'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 set of results. So let's get started by putting some data into the database.

Inserts

No, I'm not talking about those annoying cards you find in books or magazines when you first open them. The context here is inserting data into a relational database. To insert data into a relational database from PL/SQL, ...

Get Beginning PL/SQL: From Novice to Professional now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.