作者:empty 页数:180 出版社:empty |
de tn mon, Dra deP LSQ.Langage Pack tRec ie nz.theme age c caneand da ed traded res arc trade murksedORellMdtiIne Many of thedeign at unst red by manufactuer and sl least odsigucatheifpoduccin gsm depetdknterSunMietussgts.
IntroductionThe Or ad ePL/SQL Language Pocket ReJ erences a quik reference guide to the PL/SQL programming language, whichprov des procedural exten st on stu the SQL relational data-base language and a range of Oracle development toolswher ca pack agr.prg am, orunctonssuppuredunlyfurapameuarveaonoftheOraded at base eg.Or aeD a abase iig.we in dba eths in the tex.The purp use of this pocket reference is to help PL/SQL usersfind the syntax of specific language elements.It is not a self-contained userguide, bas acknowledge of the PL/SQL pro-gramming language is assumed.For more information.seethe full owing OReilly bao ks:Oracle PL/SQLPragramtnig, Four hE dht n, by StevenFeuerstein with Bill Pribyl
AcknowledgmentsWe are grateful to all those who helped in the preparation ofthis book.In particular, thanks to Bryn Llewellyn for hisinput on this latest revision as wll as the third edition.Thanks as well to frst-edtionrevewersEneJGivler andStephen Nelson and to second-and third-edition reviewerJonathan Gen nick.In addition, we appreciate all the goodwork by the O'Ret lly crew in editing and producing thisbook.
Referencing Fields of Records
Assigning Records
Records and DML
Nested Records
Collections in PL/SQL
Declaring a Collection
Initializing a Collection
Adding and Removing Elements
Nested Table Functions
Collection Methods
Collections and Privileges
Nested Collections
Bulk Binds
Built-in Functions and Packages
Buit-in Functions
Built n RegularExpression Functions
Builtin Packages
Stored Procedures and Functions
Procedures
Functions
Parameters
Local Programs
Program Overloading
Forward Deda rations
Table Functions
Function Result Cache
Privileges and Stored PL/SQL
Contents lv
Creating Triggers
Trigger Predicates
DML Events
Compound DML Triggers
DDL Events
Database Events
Packages
Package Structure
Referencing Package Elements
Package Data
SERIALLY_REUSABLE Pragma
Package Initialization
Call n gPL/SQL Functions in5QL
Calling a Function
Calling Packaged Functions in SQL
Column/Function Name Precedence
Object-Oriented Features
Object Types
Type Inheritance
Methods
Met