Oracle Database 11g PL/SQL ProgrammingDesign Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.
|
Contents
PLSQL Programming | 161 |
PLSQL Advanced Programming | 379 |
Appendixes | 569 |
Copyright | |
1 other sections not shown
Other editions - View all
Common terms and phrases
actual parameter anonymous block assign associative array BEGIN BFILE BINARY_INTEGER bind variable BLOB Boolean BOOLEAN datatype bytes Chapter CHAR clause CLOB CLOB column compilation configure connection constructor CREATE OR REPLACE data type database triggers DBMS_SQL DECLARE default define DELETE demonstrates elements END LOOP error example exception execution explicit cursor following prototype foreign key formal parameter function returns functions and procedures implement inside INTEGER item_title Java class Java programming language JDBC libraries method Microsoft Windows MULTISET NCLOB nested table null value NUMBER object type operand operator optional Oracle Database output package body package specification pass-by-reference pass-by-value PL/SQL PL/SQL block PL/SQL programs PLS_INTEGER prints program units programming language publisher's query reference cursor regular expression rows scalar schema script SELECT statement Server session SQL datatypes SQL statements SQL*Plus static string string literal structures subroutines subtype syntax trigger UPDATE user-defined