PL/SQL, Oracle’s procedural extension to SQL, is an advanced fourth-generation programming language (4GL). It offers modern features such as data encapsulation, overloading, collection types, exception handling, and information hiding. PL/SQL also offers seamless SQL access, tight integration with the Oracle server and tools, portability, and security. This guide explains all the concepts behind PL/SQL and illustrates every facet of the language. Good programming style is stressed throughout and supported by numerous examples. Using this guide, you learn PL/SQL quickly and effectively | PL SQL User s Guide and Reference Release February 1999 Part No. A67842-01 ORACL6 PL SQL User s Guide and Reference Release Part No. A67842-01 Copyright 1999 Oracle Corporation. All rights reserved. Author Tom Portfolio Graphics Artist Valarie Moore Contributors Dave Alpern Chandrasekharan Iyer Ervan Darnell Ken Jacobs Sanjay Kaluskar Sanjay Krishnamurthy Janaki Krishnaswamy Neil Le Kannan Muthukkaruppan Shirish Puranik Chris Racicot Ken Rudin Usha Sangam Ajay Sethi Guhan Viswanathan The Programs are not intended for use in any nuclear aviation mass transit medical or other inherently dangerous applications. It shall be the licensee s responsibility to take all appropriate fail-safe backup redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes and Oracle disclaims liability for any damages caused by such use of the Programs. The Programs which include both the software and documentation contain proprietary information of Oracle Corporation they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright patent and other intellectual and industrial property laws. Reverse engineering disassembly or decompilation of the Programs is prohibited. The information contained in this document is subject to change without notice. If you find any problems in the documentation please report them to us in writing. Oracle Corporation does not warrant that this document is error free. Except as may be expressly permitted in your license agreement for these Programs no part of these Programs may be reproduced or transmitted in any form or by any means electronic or mechanical for any purpose without the express written permission of Oracle Corporation. If the Programs are delivered to the . Government or anyone licensing or using the Programs on behalf of the . Government the following notice is applicable Restricted Rights Notice Programs .
