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 : 10.5. Referencing and Modifying PL/SQL Table Rows
ELSE keyword : (see IF statements)
ELSIF keyword : (see IF statements)
email, sending with external procedures : 21.7.2. Example: Sending Email
embedded PL/SQL : (see stored functions, PL/SQL)
embedding trace calls in programs : 26.5. Quick-and-Dirty Tracing
embedding quotation marks : 2.3.1. Embedding Single Quotes Inside a String
EMPTY_BLOB function : 13.2.2. The EMPTY_BLOB function
EMPTY_CLOB function : 13.2.3. The EMPTY_CLOB function
ENABLE procedure : C.9.2. The ENABLE procedure
encapsulating calculations : 17.8.1. Encapsulating Calculations
encapsulation : 18.1.5.2. Encapsulation
  of data structure access : 1.7.2. Synchronize Program and Data Structures
  on object views : 20.2.1.1. The "don't use" argument
  of persistent objects : 18.2.2.2. DDL usage
enclosed block : (see nested blocks)
encrypting code : 23.7. Encrypting Stored Code
END IF : (see IF statements)
END label
  15.4.4. The END Label
  15.5.3. The END Label
END LOOP keywords : (see loops)
ENQUEUE procedure : C.3.1.1. The ENQUEUE procedure
Enterprise Manager/Performance Pack product : 25.1. Analyzing Program Performance
entity-relationship (ER) model : 18.1.4.3. Inheritance
environment, user : 13.3.9. The USERENV function
equality, testing objects for : 18.3.6.2. Equality comparisons
ER (entity-relationship) model : 18.1.4.3. Inheritance
ERASE procedure : C.6.4. The ERASE procedure
erasing : (see deleting)
error messages
  "attribute expression within SQL expression" : 6.9. Cursor Attributes
  "cursor already open"
    6.5. Opening Cursors
    6.9.4. The %ISOPEN Attribute
  "expression is inappropriate" : 6.4.1. The Cursor Name
  "fetch out of sequence" : 6.11.1. Releasing Locks with COMMIT
  "function returned without value" : 15.5.8.3. No RETURN is executed
  "maximum open cursors exceeded" : 6.8.1. Maximum Number of Cursors
  "wrong number of values in the INTO list" : 6.6.1. Matching Column List with INTO Clause
  SQLERRM function : 13.3.6. The SQLERRM function
  "illegal GOTO statement" : 5.2.1.2. Target labels and scope of GOTO
errors
  (see also exceptions)
  8. Exception Handlers
  caused by implicit cursors : 6.3.2.2. Vulnerability to data errors
  codes for : (see SQLCODE)
  communication from server to client : 8.7. Client-Server Error Communication
  handling : 1.4.3.9. Error handling
  viewing in SQL*Plus : 23.5.4. Viewing Compilation Errors in SQL*Plus
  violation of RESTRICT_REFERENCES pragma : 17.5.1.1. Pragma violation errors
event level, tracing : 26.1.2. Turning On the Trace
EXCEPTION keyword
  8.3.2. Named Programmer-Defined Exceptions
  8.6. Handling Exceptions
EXCEPTION_INIT pragma : 8.3.3.1. The EXCEPTION_INIT pragma
exceptions
  1.4.3.9. Error handling
  8. Exception Handlers
  for branching logic : 1.7.5. Structured Code and Other Best Practices
  continuing once handled : 8.6.4. Continuing Past Exceptions
  CURSOR_ALREADY_OPEN : 8.3.1. Named System Exceptions
  declaring in packages : 16.3. The Package Specification
  DUP_VAL_ON_INDEX : 8.3.1. Named System Exceptions
  exception section of code : 8.2. The Exception Section
  formatting handlers of : 3.3.3. Formatting Exception Handlers
  handler development : 1.7.4. Standardize Your PL/SQL Development Environment
  handles for : 8.6. Handling Exceptions
  handling : 22.2.3. Avoid Exception Handlers for Normal Program Exits
    like IF statement : 8.9. Exception Handler as IF Statement
    multiple : 8.6.1. Combining Multiple Exceptions in a Single Handler
    structure for : 8.4. Determining Exception-Handling Behavior
    tips for : 8.10. RAISE Nothing but Exceptions
  INVALID_CURSOR : 8.3.1. Named System Exceptions
  INVALID_NUMBER : 8.3.1. Named System Exceptions
  LOGIN_DENIED : 8.3.1. Named System Exceptions
  NO_DATA_FOUND
    8.3.1. Named System Exceptions
    8.8. NO_DATA_FOUND: Multipurpose Exception
  NOT_LOGGED_ON : 8.3.1. Named System Exceptions
  nullifying effect of raised : 5.2.2.2. Nullifying the effect of a raised exception
  overlapping names of : 8.4.1.3. Overlapping exception names
  as package : 16.3.1.1. A package of exceptions
  PROGRAM_ERROR : 8.3.1. Named System Exceptions
  programmer-defined
    8.3.2. Named Programmer-Defined Exceptions
    8.3.4. Unnamed Programmer-Defined Exceptions
  propagation of : 8.4.2. Propagation of an Exception
  raised within handler : 8.5.4. Exceptions Raised in an Exception Handler
  raising
    8.5. Raising an Exception
    8.10. RAISE Nothing but Exceptions
  ROWTYPE_MISMATCH : 6.12.5.2. Handling the ROWTYPE_MISMATCH exception
  scope of : 8.4.1. Scope of an Exception
  SQLCODE function : 13.3.5. The SQLCODE function
  STORAGE_ERROR : 8.3.1. Named System Exceptions
  system : 8.3.1. Named System Exceptions
  TIMEOUT_ON_RESOURCE : 8.3.1. Named System Exceptions
  TOO_MANY_ROWS : 8.3.1. Named System Exceptions
  TRANSACTION_BACKED_OUT : 8.3.1. Named System Exceptions
  trapping invalid arguments : 22.2.4.1. Trap invalid argument values
  types of : 8.3. Types of Exceptions
  VALUE_ERROR : 8.3.1. Named System Exceptions
  ZERO_DIVIDE : 8.3.1. Named System Exceptions
execute authority
  1.3.2. Improved Execution Authority and Transaction Integrity with PL/SQL
  23.2. Transaction Integrity and Execute Authority
  collections and : 19.8.1. Privileges
  packages and : 23.2.1. Execute Authority on Stored Objects
  sharing code and : 23.1.4. Key Concepts for Program Execution
  on stored objects : 23.2.1. Execute Authority on Stored Objects
EXECUTE command
  C.14.6. The EXECUTE function
  23.1.1. Executing Procedures
  23.5.3. Changing Stored Objects
  EXECUTE_AND_FETCH command : C.14.7. The EXECUTE_AND_FETCH function
execution, shared code : 23.1. Executing Stored Code
EXISTS function
  10.8.2.3. The EXISTS function
  19.6.3. EXISTS(i)
EXIT statement
  (see also loops)
  7.2.1. Terminating a Simple Loop: EXIT and EXIT WHEN
  7.7.2.2. EXIT and EXIT WHEN statements
  EXIT WHEN statement
    7.2.1. Terminating a Simple Loop: EXIT and EXIT WHEN
    7.2.2. Emulating a REPEAT UNTIL Loop
    7.7.2.2. EXIT and EXIT WHEN statements
  with loop labels : 7.6.1.2. Loop termination using labels
EXIT WHEN statement
  (see also loops)
  7.2.1. Terminating a Simple Loop: EXIT and EXIT WHEN
exiting loops : 1.7.5. Structured Code and Other Best Practices
EXP function : 13.1.9. The EXP function
EXPLAIN PLAN statement : 25.1. Analyzing Program Performance
explicit
  conversion functions : 14. Conversion Functions
  cursors
    (see also cursors)
    1.7.4. Standardize Your PL/SQL Development Environment
    6.2.1. Types of Cursors
    6.3.3. Explicit Cursors
    fetching from
      9.5.3. FETCH INTO from an Explicit Cursor 1.7.2. Synchronize Program and Data Structures
explicit datatype conversion : 4.2.8.1. Explicit data conversions
exponents : 13.1.14. The POWER function
EXTEND procedure : 19.6.4. EXTEND [ (n [,i] ) ]
  adding collection elements : 19.4.3.1. Adding elements using EXTEND
extensions, filename : (see filenames)
external
  LOBs : 1.4.7.6. Large object support
  procedures : 1.4.7.5. External procedures
EXTERNAL clause : 21.3.2. EXTERNAL: Creating the PL/SQL Body
external datatypes : 21.4.1. Datatype Conversion
external procedures : 21. External Procedures
  architecture of : 21.1.2. Architecture
  creating : 21.2. Steps in Creating an External Procedure
  data dictionary entries : 21.6.1. Data Dictionary
  debugging : 21.6.2. Rules and Warnings About External Procedures
  examples : 21.7. Examples
  listeners for : 21.2.1. Step 1: Set Up the Listener
  mapping parameters : 21.4. Mapping Parameters
  OCI routines for : 21.5. OCI Service Routines
  syntax : 21.3. Syntax for External Procedures
  warnings about : 21.6.2. Rules and Warnings About External Procedures
EXTERNAL_PROCEDURE_LISTENER listener : 21.2.1. Step 1: Set Up the Listener

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

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.