Whoa! One Statement at a Time, Please!

Abstract

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.