Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z

Index: E

• editing table rows : Referencing and Modifying PL/SQL Table Rows
• ELSE keyword : (see IF statements)
• ELSIF keyword : (see IF statements)
• email, sending with external procedures : Example: Sending Email
• embedded PL/SQL : (see stored functions, PL/SQL)
• embedding trace calls in programs : Quick-and-Dirty Tracing
• embedding quotation marks : Embedding Single Quotes Inside a String
• EMPTY_BLOB function : The EMPTY_BLOB function
• EMPTY_CLOB function : The EMPTY_CLOB function
• ENABLE procedure : The ENABLE procedure
• encapsulating calculations : Encapsulating Calculations
• encapsulation : Encapsulation
• • of data structure access : Synchronize Program and Data Structures
  • on object views : The "don't use" argument
  • of persistent objects : DDL usage
• enclosed block : (see nested blocks)
• encrypting code : Encrypting Stored Code
• END IF : (see IF statements)
• END label
• • The END Label
  • The END Label
• END LOOP keywords : (see loops)
• ENQUEUE procedure : The ENQUEUE procedure
• Enterprise Manager/Performance Pack product : Analyzing Program Performance
• entity-relationship (ER) model : Inheritance
• environment, user : The USERENV function
• equality, testing objects for : Equality comparisons
• ER (entity-relationship) model : Inheritance
• ERASE procedure : The ERASE procedure
• erasing : (see deleting)
• error messages
• • "attribute expression within SQL expression" : Cursor Attributes
  • "cursor already open"
  • • Opening Cursors
    • The %ISOPEN Attribute
  • "expression is inappropriate" : The Cursor Name
  • "fetch out of sequence" : Releasing Locks with COMMIT
  • "function returned without value" : No RETURN is executed
  • "maximum open cursors exceeded" : Maximum Number of Cursors
  • "wrong number of values in the INTO list" : Matching Column List with INTO Clause
  • SQLERRM function : The SQLERRM function
  • "illegal GOTO statement" : Target labels and scope of GOTO
• errors
• • (see also exceptions)
  • Exception Handlers
  • caused by implicit cursors : Vulnerability to data errors
  • codes for : (see SQLCODE)
  • communication from server to client : Client-Server Error Communication
  • handling : Error handling
  • viewing in SQL*Plus : Viewing Compilation Errors in SQL*Plus
  • violation of RESTRICT_REFERENCES pragma : Pragma violation errors
• event level, tracing : Turning On the Trace
• EXCEPTION keyword
• • Named Developer-Defined Exceptions
  • Handling Exceptions
• EXCEPTION_INIT pragma : The EXCEPTION_INIT pragma
• exceptions
• • Error handling
  • Exception Handlers
  • for branching logic : Structured Code and Other Best Practices
  • continuing once handled : Continuing Past Exceptions
  • CURSOR_ALREADY_OPEN : Named System Exceptions
  • declaring in packages : The Package Specification
  • DUP_VAL_ON_INDEX : Named System Exceptions
  • exception section of code : The Exception Section
  • formatting handlers of : Formatting Exception Handlers
  • handler development : Standardize Your PL/SQL Development Environment
  • handles for : Handling Exceptions
  • handling : Avoid Exception Handlers for Normal Program Exits
  • • like IF statement : Exception Handler as IF Statement
    • multiple : Combining Multiple Exceptions in a Single Handler
    • structure for : Determining Exception-Handling Behavior
    • tips for : RAISE Nothing but Exceptions
  • INVALID_CURSOR : Named System Exceptions
  • INVALID_NUMBER : Named System Exceptions
  • LOGIN_DENIED : Named System Exceptions
  • NO_DATA_FOUND
  • • Named System Exceptions
    • NO_DATA_FOUND: Multipurpose Exception
  • NOT_LOGGED_ON : Named System Exceptions
  • nullifying effect of raised : Nullifying the effect of a raised exception
  • overlapping names of : Overlapping exception names
  • as package : package of exceptions
  • PROGRAM_ERROR : Named System Exceptions
  • developer-defined
  • • Named Developer-Defined Exceptions
    • Unnamed Developer-Defined Exceptions
  • propagation of : Propagation of an Exception
  • raised within handler : Exceptions Raised in an Exception Handler
  • raising
  • • Raising an Exception
    • RAISE Nothing but Exceptions
  • ROWTYPE_MISMATCH : Handling the ROWTYPE_MISMATCH exception
  • scope of : Scope of an Exception
  • SQLCODE function : The SQLCODE function
  • STORAGE_ERROR : Named System Exceptions
  • system : Named System Exceptions
  • TIMEOUT_ON_RESOURCE : Named System Exceptions
  • TOO_MANY_ROWS : Named System Exceptions
  • TRANSACTION_BACKED_OUT : Named System Exceptions
  • trapping invalid arguments : Trap invalid argument values
  • types of : Types of Exceptions
  • VALUE_ERROR : Named System Exceptions
  • ZERO_DIVIDE : Named System Exceptions
• execute authority
• • Improved Execution Authority and Transaction Integrity with PL/SQL
  • Transaction Integrity and Execute Authority
  • collections and : Privileges
  • packages and : Execute Authority on Stored Objects
  • sharing code and : Key Concepts for Program Execution
  • on stored objects : Execute Authority on Stored Objects
• EXECUTE command
• • The EXECUTE function
  • Executing Procedures
  • Changing Stored Objects
  • EXECUTE_AND_FETCH command : The EXECUTE_AND_FETCH function
• execution, shared code : Executing Stored Code
• EXISTS function
• • The EXISTS function
  • EXISTS(i)
• EXIT statement
• • (see also loops)
  • Terminating a Simple Loop: EXIT and EXIT WHEN
  • EXIT and EXIT WHEN statements
  • EXIT WHEN statement
  • • Terminating a Simple Loop: EXIT and EXIT WHEN
    • Emulating a REPEAT UNTIL Loop
    • EXIT and EXIT WHEN statements
  • with loop labels : Loop termination using labels
• EXIT WHEN statement
• • (see also loops)
  • Terminating a Simple Loop: EXIT and EXIT WHEN
• exiting loops : Structured Code and Other Best Practices
• EXP function : The EXP function
• EXPLAIN PLAN statement : Analyzing Program Performance
• explicit
• • conversion functions : Conversion Functions
  • cursors
  • • (see also cursors)
    • Standardize Your PL/SQL Development Environment
    • Types of Cursors
    • Explicit Cursors
    • fetching from
    • • FETCH INTO from an Explicit Cursor Synchronize Program and Data Structures
• explicit datatype conversion : Explicit data conversions
• exponents : The POWER function
• EXTEND procedure : EXTEND [ (n [,i] ) ]
• • adding collection elements : Adding elements using EXTEND
• extensions, filename : (see filenames)
• external
• • LOBs : Large object support
  • procedures : External procedures
• EXTERNAL clause : EXTERNAL: Creating the PL/SQL Body
• external datatypes : Datatype Conversion
• external procedures : External Procedures
• • architecture of : Architecture
  • creating : Steps in Creating an External Procedure
  • data dictionary entries : Data Dictionary
  • debugging : Rules and Warnings About External Procedures
  • examples : Examples
  • listeners for : Step 1: Set Up the Listener
  • mapping parameters : Mapping Parameters
  • OCI routines for : OCI Service Routines
  • syntax : Syntax for External Procedures
  • warnings about : Rules and Warnings About External Procedures
• EXTERNAL_PROCEDURE_LISTENER listener : Step 1: Set Up the Listener