SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK ORACLE PLSQL LANGUAGE POCKET REFERENCE 4TH EDITION
SUMMARY
-
Items Found: 116
- Introduction 1
- Acknowledgments 1
- Conventions 2
- PL/SQL Language Fundamentals 2
- PL/SQL Character Set 2
- Identifiers 3
- Boolean, Numeric, and String Literals 4
- Numeric Literals 5
- Datetime Interval Literals 6
- Delimiters 6
- Comments 8
- Pragmas 8
- Statements 9
- Block Structure 9
- Variables and Program Data 11
- Scalar Datatypes 12
- LOB Datatypes 18
- Implicit Datatype Conversions 19
- NULLs in PL/SQL 19
- Declaring Variables 19
- Anchored Declarations 22
- Programmer-Defined Subtypes 23
- Conditional and Sequential Control 23
- Conditional Control Statements 23
- Sequential Control Statements 27
- Loops 28
- Simple Loop 29
- Numeric FOR Loop 29
- Cursor FOR Loop 30
- WHILE Loop 30
- REPEAT UNTIL Loop Emulation 31
- EXIT Statement 31
- CONTINUE Statement (Oracle Database 11g) 31
- Loop Labels 33
- Database Interaction 34
- Sequences in PLSQL 34
- Transaction Management 34
- Autonomous Transactions 37
- Cursors in PL/SQL 38
- Explicit Cursors 38
- Implicit Cursors 42
- Dynamic Cursors 45
- DBMS_SQL 46
- SQL Injection and Bind Variables 47
- Cursor Variables 48
- Cursor Expressions 49
- Exception Handling 50
- Declaring Exceptions 51
- Raising Exceptions 53
- Scope 54
- Propagation 54
- Records in PL/SQL 56
- Declaring Records 57
- Referencing Fields of Records 58
- Assigning Records 58
- Records and DML 59
- Nested Records 60
- Collections in PL/SQL 61
- Declaring a Collection 63
- Initializing a Collection 64
- Adding and Removing Elements 65
- Nested Table Functions 65
- Collection Methods 68
- Collections and Privileges 71
- Nested Collections 71
- Bulk Binds 71
- Built-in Functions and Packages 75
- Built-in Functions 75
- Built-in Regular Expression Functions 87
- Built-in Packages 93
- Stored Procedures and Functions 97
- Procedures 98
- Functions 99
- Parameters 100
- Local Programs 103
- Program Overloading 104
- Forward Declarations 106
- Table Functions 106
- Function Result Cache 107
- Privileges and Stored PL/SQL 109
- Triggers 109
- Creating Triggers 110
- Trigger Predicates 114
- DML Events 114
- Compound DML Triggers 115
- DDL Events 117
- Database Events 117
- Packages 117
- Package Structure 118
- Referencing Package Elements 120
- Package Data 120
- SERIALLY_REUSABLE Pragma 120
- Package Initialization 121
- Calling PL/SQL Functions in SQL 122
- Calling a Function 123
- Calling Packaged Functions in SQL 124
- Column/Function Name Precedence 125
- Object-Oriented Features 125
- Object Types 126
- Type Inheritance 128
- Methods 128
- Methods in Subtypes 132
- Manipulating Objects in PL/SQL and SQL 133
- Upcasting and Downcasting 135
- Changing Object Types 138
- Compilation 139
- Compiling Stored PL/SQL Programs 140
- Conditional Compilation 142
- Compiler Warnings 145
- Optimizing Compiler 147
- Performing Native Compilation of PL/SQL 149
- Java Language Integration 152
- Example 153
- Publishing Java to PL/SQL 154
- Data Dictionary 155
- Index 157
