Oracle PL/SQL language : pocket reference

Oracle PL/SQL language : pocket reference

This pocket reference provides quick-reference information that will help you use Oracle's PL/SQL language. It is a companion to Steven Feuerstein and Bill Pribyl's bestselling book, Oracle PL/SQL Programming , and includes coverage of the latest version of Oracle, Oracle8i. Oracle is the...

Descripción completa

Detalles Bibliográficos
Autor Corporativo: Safari Tech Books Online (-)
Otros Autores: Feuerstein, Steven Author (author), Pribyl, Bill Contributor (contributor), Dawes, Chip Contributor
Formato: Libro electrónico
Idioma:Inglés
Publicado: [Place of publication not identified] O'Reilly 1999
Edición:1st edition
Materias:
Oracle (Computer file)
Relational databases
PL/SQL (Computer program language)
Engineering & Applied Sciences
Computer Science
Electronic books.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627328206719
Tabla de Contenidos:
  • 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
  • Unicode character datatypes
  • Datetime datatypes
  • BOOLEAN datatype
  • 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
  • CONTINUE Statement (Oracle Database 11g)
  • Loop Labels
  • Database Interaction
  • Sequences in PLSQL
  • 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
  • DBMS_SQL
  • SQL Injection and Bind Variables
  • Cursor Variables
  • Cursor Expressions
  • Exception Handling
  • Declaring Exceptions
  • Raising Exceptions
  • Scope
  • Propagation
  • WHEN OTHERS clause
  • SQLCODE, SQLERRM, and DBMS_UTILITY.FORMAT_ CALL_STACK
  • Exceptions and DML.
  • Records in PL/SQL
  • Declaring Records
  • 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
  • Built-in Functions
  • Conversion functions
  • String functions
  • Numeric functions
  • Datetime functions
  • Built-in Regular Expression Functions
  • Metacharacters
  • REGEXP_COUNT (Oracle Database 11g)
  • REGEXP_LIKE
  • REGEXP_INSTR
  • REGEXP_SUBSTR
  • REGEXP_REPLACE
  • Match modifiers
  • Built-in Packages
  • Stored Procedures and Functions
  • Procedures
  • Functions
  • Parameters
  • Datatype
  • Mode
  • Default values
  • Parameter-passing notations
  • Local Programs
  • Program Overloading
  • Forward Declarations
  • Table Functions
  • Function Result Cache
  • Privileges and Stored PL/SQL
  • Triggers
  • 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
  • Calling PL/SQL Functions in SQL
  • Calling a Function
  • Calling Packaged Functions in SQL
  • Column/Function Name Precedence
  • 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
  • Compilation
  • Compiling Stored PL/SQL Programs
  • Conditional Compilation
  • Compiler Warnings
  • Optimizing Compiler
  • Performing Native Compilation of PL/SQL.
  • Oracle9i Database
  • Oracle Database 10g
  • Oracle Database 11g
  • Java Language Integration
  • Example
  • Publishing Java to PL/SQL
  • Data Dictionary
  • Index.

Ejemplares similares