
Oracle PL/SQL Language Pocket Reference
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Intro
- Contents
- Oracle PL/SQL Language Pocket Reference
- Introduction
- Acknowledgments
- Conventions
- PL/SQL Language Fundamentals
- PL/SQL Character Set
- Identifiers
- Boolean, Numeric, and String Literals
- Numeric Literals
- Datetime Interval Literals
- Delimiters
- Comments
- Pragmas
- Statements
- Block Structure
- Variables and Program Data
- Scalar Datatypes
- Numeric datatypes
- Character datatypes
- Datetime datatypes
- BOOLEAN datatype
- NLS Character Datatypes
- LOB Datatypes
- Implicit Datatype Conversions
- NULLs in PL/SQL
- Declaring Variables
- Constrained declarations
- Constants
- Default values
- Anchored Declarations
- Programmer-Defined Subtypes
- Conditional and Sequential Control
- Conditional Control Statements
- IF-THEN combination
- IF-THEN-ELSE combination
- IF-THEN-ELSIF combination
- CASE statement
- CASE expression
- Sequential Control Statements
- GOTO
- NULL
- Loops
- Simple Loop
- Numeric FOR Loop
- Cursor FOR Loop
- WHILE Loop
- REPEAT UNTIL Loop Emulation
- EXIT Statement
- Loop Labels
- Database Interaction
- Transaction Management
- COMMIT
- ROLLBACK
- SAVEPOINT
- SET TRANSACTION
- LOCK TABLE
- Autonomous Transactions
- Cursors in PL/SQL
- Explicit Cursors
- Declaring explicit cursors
- Opening explicit cursors
- Fetching from explicit cursors
- Closing explicit cursors
- Explicit cursor attributes
- Implicit Cursors
- SELECT FOR UPDATE clause
- WHERE CURRENT OF clause
- Dynamic Cursors
- Cursor Variables
- Cursor Expressions
- Exception Handling
- Declaring Exceptions
- Raising Exceptions
- Scope
- Propagation
- WHEN OTHERS clause
- SQLCODE and SQLERRM
- Exceptions and DML
- Records in PL/SQL
- Declaring Records
- Referencing Fields of Records
- Assigning Records
- DML and Records
- Nested Records
- Named Program Units
- Procedures
- Functions
- Parameters
- Datatype
- Mode
- Default values
- Parameter-passing notations
- Local programs
- Program overloading
- Forward declarations
- Table functions
- Compiling stored PL/SQL programs
- Compiler warnings (Oracle Database 10g)
- The optimizing compiler (Oracle Database 10g)
- Performing native compilation of PL/SQL
- Privileges and stored PL/SQL
- Triggers
- Creating Triggers
- Trigger Predicates
- DML Events
- DDL Events
- Database Events
- Packages
- Package Structure
- Referencing Package Elements
- Package Data
- SERIALLY_REUSABLE Pragma
- Package Initialization
- Calling PL/SQL Functions in SQL
- Calling a Function
- Requirements and Restrictions
- Calling Packaged Functions in SQL
- Column/Function Name Precedence
- Oracle's Object-Oriented Features
- Object Types
- Type Inheritance
- Methods
- Member methods
- Static methods
- Constructor methods
- Comparison methods
- Methods in Subtypes
- Manipulating Objects in PL/SQL and SQL
- Upcasting and Downcasting
- REF operator
- VALUE operator
- DEREF operator
- Changing Object Types
- Collections
- Declaring a Collection
- Initializing a Collection
- Adding and Removing Elements
- Nested Table Functions
- Collection Methods
- Collections and Privileges
- Nested Collections
- Bulk Binds
- External Procedures
- Creating an External Procedure
- Set up the listener
- Identify or create the shared library or DLL
- Create the library in the database
- Create the PL/SQL wrapper for the external procedure
- Parameters
- Java Language Integration
- Example
- Publishing Java to PL/SQL
- Data Dictionary
- Regular Expressions (Oracle Database 10g)
- Metacharacters
- REGEXP_LIKE
- REGEXP_INSTR
- REGEXP_SUBSTR
- REGEXP_REPLACE
- Match Modifiers
- Reserved Words
- Index
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.