Murach's Oracle SQL and PL/SQL
How to write PL/SQL code

This chapter shows you the basics of coding scripts using PL/SQL, Oracle's procedural language. PL/SQL provides the kind of functionality that's available in programming languages like Java, C++, C# and Visual Basic.
Chapter 13 How to write PL/SQL code
An introduction to PL/SQL 410
An anonymous PL/SQL block in a script 410
A summary of statements for working with PL/SQL and scripts 412
How to code the basic PL/SQL statements 414
How to print data to an output window 414
How to declare and use vaiables 416
How to code IF statements 418
How to code CASE statements 420
How to code loops 422
How to use a cursor 424
How to use collections 426
How to handle exceptions 430
A list of predifined exceptions 432
Other scripting and PL/SQL skills 434
How to drop database objects without displaying errors 434
How to use bind variables 436
How to use substitution variables 436
How to use dynamic SQL 438
How to run a script from a command line 440


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.