Skip to Main Content
Beginning Oracle PL/SQL, Second Edition
book

Beginning Oracle PL/SQL, Second Edition

by Donald J. Bales
May 2015
Beginner content levelBeginner
492 pages
11h 48m
English
Apress
Content preview from Beginning Oracle PL/SQL, Second Edition

Introduction (The Big Picture)

This is a book about writing stored procedures for an Oracle database. A stored procedure in this context is a generic term for a program written in the Procedure Language extension for SQL (PL/SQL) that is stored inside the database when it is compiled. This means that you can then execute the program from inside the database. Why would you want to do this? Because your program will run faster inside the database.

Let’s slow down for a minute, so I can explain what a stored procedure is and why you would want to use one.

What’s a Stored Procedure?

In order for me to talk about stored procedures, I need to cover a little material on databases and networks first. By now, you’ve probably already seen three of the ...

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 Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

Steven Feuerstein, Bill Pribyl, Chip Dawes
Oracle PL/SQL Programming: A Developer's Workbook

Oracle PL/SQL Programming: A Developer's Workbook

Steven Feuerstein, Andrew Odewahn

Publisher Resources

ISBN: 9781484207376Purchase book