Skip to Main Content
Oracle PL/SQL for DBAs
book

Oracle PL/SQL for DBAs

by Arup Nanda, Steven Feuerstein
October 2005
Intermediate to advanced content levelIntermediate to advanced
454 pages
14h 44m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL for DBAs

Chapter 1. Introduction to PL/SQL

PL/SQL stands for Procedural Language extensions to the Structured Query Language. SQL is the now-ubiquitous language for both querying and updating—never mind the name—of relational databases. Oracle Corporation introduced PL/SQL to overcome some limitations in SQL and to provide a more complete programming solution for those who sought to build mission-critical applications to run against the Oracle database. This chapter introduces PL/SQL and its origins, and it provides a quick overview of the basic elements of the language.

Our expectation is not to have you read this chapter and then immediately be able to write top-notch PL/SQL programs, but rather to make sure that you have sufficient grounding in the language to understand and work with the functionality and examples presented in the rest of this book. We’ll try to give you an appreciation of the breadth of PL/SQL while focusing on the features that you are most likely to use as a DBA.

There is a lot more to PL/SQL than we have room to include in this chapter, long as it is. If you have not previously written PL/SQL programs and scripts, we encourage you to check out Learning Oracle PL/SQL and Oracle PL/SQL Programming, two other O’Reilly books on PL/SQL that will give you much more information and guidance.

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

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 0596005873Supplemental ContentErrata Page