+612 9045 4394
 
CHECKOUT
Oracle Database 10g PL/SQL Programming : Oracle Press - Scott Urman

Oracle Database 10g PL/SQL Programming

Oracle Press

Paperback Published: 1st September 2004
ISBN: 9780072230666
Number Of Pages: 896

Share This Book:

Paperback

RRP $84.95
$83.75
or 4 easy payments of $20.94 with Learn more
Ships in 7 to 10 business days

Create dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. You’ll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions.

Introduction
Introduction to PL/SQLp. 3
Introduction to Programming Languagesp. 4
PL/What?p. 6
Language Fundamentalsp. 15
PL/SQL Statement Processingp. 17
Getting the Most from This Bookp. 18
Summaryp. 21
Using SQL*Plus and JDeveloperp. 23
SQL*Plusp. 24
JDeveloperp. 34
Summaryp. 43
PL/SQL Basicsp. 45
The PL/SQL Blockp. 46
Language Rules and Conventionsp. 64
PL/SQL Data Typesp. 77
Using Variablesp. 89
Hiding Codep. 97
Expressionsp. 100
Controlling Program Flowp. 102
Summaryp. 115
Using SQL with PL/SQLp. 117
Transaction Processingp. 118
Retrieving Datap. 130
Cursorsp. 142
DML and DDLp. 158
Using ROWID and ROWNUMp. 165
Built-in SQL Functionsp. 172
Summaryp. 179
Recordsp. 181
Introducing Recordsp. 182
Summaryp. 212
Collectionsp. 213
Introducing Collectionsp. 214
Working with Collectionsp. 214
Oracle 10g Collection APIp. 282
Summaryp. 302
Error Handlingp. 303
What Is an Exception?p. 304
Exception Propagationp. 323
Exception Guidelinesp. 329
Summaryp. 334
Creating Procedures, Functions, and Packagesp. 335
Procedures and Functionsp. 336
Packagesp. 367
Summaryp. 380
Using Procedures, Functions, and Packagesp. 381
Subprogram Locationsp. 382
Considerations of Stored Subprograms and Pakcagesp. 393
Stored Functions and SQL Statementsp. 424
Native Compilationp. 439
Pinning in the Shared Poolp. 440
Summaryp. 442
Database Triggersp. 443
Types of Triggersp. 444
Creating Triggersp. 449
Mutating Tablesp. 488
Summaryp. 495
Advanced PL/SQL Features
Intersession Communicationp. 499
Introducing Intersession Communicationp. 500
The DBMS_PIPE Built-in Packagep. 502
DBMS_ALERT Built-in Packagep. 530
Summaryp. 542
External Routinesp. 543
Introducing External Proceduresp. 544
Working with External Proceduresp. 545
Troubleshooting the Shared Libraryp. 575
Summaryp. 581
Dynamic SQLp. 583
Introducing Dynamic SQLp. 585
Working with Native Dynamic SQLp. 586
Working with the Oracle DBMS_SQL Built-in Packagep. 609
Summaryp. 634
Introduction to Objectsp. 635
Introduction to Object-Oriented Programmingp. 636
Object Type Overviewp. 637
Creating Object Typesp. 638
Object Type Inheritancep. 652
Attribute Chainingp. 663
Making Changesp. 666
Summaryp. 672
Objects in the Databasep. 673
Introduction to Objects in the Databasep. 674
Accessing Persistent Objects Using SQL and PL/SQLp. 685
Maintaining Persistent Objectsp. 705
Summaryp. 709
Large Objectsp. 711
Introduction to Large Objectsp. 712
LOBs and SQLp. 725
LOBs and PL/SQLp. 730
Performance Considerationsp. 758
Summaryp. 765
Scheduling Tasksp. 767
Introducing DBMS_JOBp. 768
Oracle Schedulerp. 780
Summaryp. 788
Appendixes
PL/SQL Reserved Wordsp. 791
Table of Reserved Wordsp. 792
Guide to Supplied Packagesp. 795
SYS-Owned Built-in Packagesp. 796
CTXSYS-Owned Built-in Packagesp. 827
Indexp. 839
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780072230666
ISBN-10: 0072230665
Series: Oracle Press
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 896
Published: 1st September 2004
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.3 x 18.6  x 4.7
Weight (kg): 1.44
Edition Number: 1