| |
 |
|
Oracle Tips by Burleson |
Using
SQL and Cursors
So far we have focused on the programmatic part of
PL/SQL, how to define and use variables, controlling program flow, and
catching program exceptions. These are all important topics, but all
programming languages implement these capabilities. The capability
that really sets PL/SQL apart from other languages is its ability to
interact with the data in the database.
This chapter will focus on retrieving and
manipulating data from Oracle and we will discuss retrieving,
inserting and updating data. We start with the SELECT INTOuery
which is used to retrieve one and only one row of data from the
database.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
