Skip to Main Content
Learning Oracle PL/SQL
book

Learning Oracle PL/SQL

by Bill Pribyl, Steven Feuerstein
November 2001
Beginner content levelBeginner
424 pages
11h 11m
English
O'Reilly Media, Inc.
Content preview from Learning Oracle PL/SQL

Chapter 5. Fetch!

In the past few chapters, we've made quite a bit of progress learning the fundamentals of the PL/SQL language, and we've had some fun creating simple web pages that will call PL/SQL programs. But we haven't yet had much of a chance to retrieveinformation from the database into PL/SQL. Why not? Isn't reading data easier than creating it? It would be, except for the fact that you have to deal with lots of rows, one at a time.

This chapter explains how to get data from the database into your stored programs. We will explore:

  • Putting simple SELECT statements into your program, whether they retrieve zero or one or more rows

  • Incorporating these techniques into the creation of a web-based search application for the library system, introducing a technique called native dynamic SQL

  • An overview of more advanced topics such as concurrency control, performance, and sophisticated queries using the Oracle Text facility

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Learning Oracle PL/SQL

Learning Oracle PL/SQL

Darryl Hurley
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl

Publisher Resources

ISBN: 0596001800Supplemental ContentCatalog PageErrata