Advertisement

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.

Keywords

Unique Constraint Select Statement Update Statement Code Table Delete Statement 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Donald J. Bales 2007

Personalised recommendations