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: F

FALSE : (see Boolean literals)
FCLOSE procedure : C.17.1.1. The FCLOSE procedure
FCLOSE_ALL procedure : C.17.1.2. The FCLOSE_ALL procedure
FETCH clause, assigning objects : 18.4.1.3. Assignment via FETCH (with SELECT)
FETCH INTO statement : 9.5.3. FETCH INTO from an Explicit Cursor
FETCH statement
  (see also cursors)
  4.2.3.2. The VARCHAR2 and VARCHAR datatypes
  6.2.2. Cursor Operations
  6.6. Fetching from Cursors
  with cursor variables : 6.12.5. Fetching from Cursor Variables
  initializing collections : 19.4.1.3. Initializing implicitly via fetch
FETCH_ROW function : C.14.8. The FETCH_ROWS function
fetching
  from cursor variables : 6.12.5. Fetching from Cursor Variables
  from cursors : 6.6. Fetching from Cursors
    checking status of FETCH : 6.9.1. The %FOUND Attribute
  to cursors, multiple times : 6.13.1.2. Using multiple fetches more efficiently
FFLUSH procedure : C.17.1.3. The FFLUSH procedure
fields, record : (see records)
FILECLOSE procedure : C.6.5. The FILECLOSE procedure
FILECLOSEALL procedure : C.6.6. The FILECLOSEALL procedure
FILEEXISTS function : C.6.7. The FILEEXISTS function
FILEGETNAME procedure : C.6.8. The FILEGETNAME procedure
FILEISOPEN function : C.6.9. The FILEISOPEN function
filenames, encrypted file extensions : 23.7.2. Working with Encrypted Code
FILEOPEN procedure : C.6.10. The FILEOPEN procedure
files
  encrypted code, size of : 23.7.3. Impact of Encrypting Code
  operating system : C.17. UTL_FILE
  for package specifications : 1.7.3. Center All Development Around Packages
filtering trace information : 26.2.3. Filtering Trace Information
FIRST function
  10.8.2.4. The FIRST function
  19.6.5. FIRST, LAST
fixed-point numbers : 4.2.2. Numeric Subtypes
FLOAT subtype : 4.2.2. Numeric Subtypes
floating-point numbers : 4.2.2. Numeric Subtypes
FLOOR function : 13.1.10. The FLOOR function
FM (fill mode) modifier : 14.3.1. FM: Suppressing Blanks and Zeros
FOPEN function : C.17.1.4. The FOPEN function
FOR loops
  1.7.1. Write as Little Code as Possible
  1.7.5. Structured Code and Other Best Practices
  cursor
    1.6.4. The cursor FOR loop
    7.4. The Cursor FOR Loop
  formatting : 3.3.2. Formatting Loops
  numeric : 7.3. The Numeric FOR Loop
  premature termination of : 7.7.2.1. Premature FOR loop termination
  scope of : 7.6.2.1. Scope in FOR loops
FORCE parameter : 18.3.2. CREATE TYPE and DROP TYPE: Creating and Dropping Types
forced compilation : 20.7.3. Forcing Compilation
foreign key
  lookups, optimizing in tables : 10.9.5. Optimizing Foreign Key Lookups with PL/SQL Tables
  object reference versus : 18.2.3. Adding Complex Data Structures
  validating entry of (example) : 6.13.1. Validating Foreign Key Entry with Cursors
formal parameters
  15.6.3. Actual and Formal Parameters
  naming : 22.1.2. Develop Consistent Naming Conventions for Your Formal Parameters
format
  FM and FX modifiers : 14.3.1. FM: Suppressing Blanks and Zeros
  models : 14.1. Conversion Formats
  RR model : 14.3.3. RR: Changing Millenia
  verifying string : 11.2.5. Verifying String Formats with TRANSLATE
FORMAT_CALL_STACK function : C.16.4. The FORMAT_CALL_STACK function
FORMAT_ERROR_STACK function : C.16.5. The FORMAT_ERROR_STACK function
formatting code : 3.1. Fundamentals of Effective Layout
forward declarations : 15.9. Forward Declarations
forward type definitions : 18.3.5.1. Forward type definitions
%FOUND cursor attribute : 6.9.1. The %FOUND Attribute
free format trace filtering : 26.3. Free Format Filtering
functional abstraction : 18.1.5.3. Abstraction
functions
  (see also modules)
  1.4.3.10. Modular construction
  15. Procedures and Functions
  15.5. Functions
  22.1.1. Make Sure the Module Name Explains the Module
  22.2. Build the Most Functional Functions
  built-in
    1.4.3.5. Built-in functions
    1.6.2. Built-in functions
  for characters, strings : 11. Character Functions
  for collections
    built-in : 19.6. Collection Built-Ins
    pseudo-functions : 19.5. Collection Pseudo-Functions
  collections as return values : 19.2.2.4. Collections as the datatype of a function's return value
  conversion : 14. Conversion Functions
  date and time : 12. Date Functions
  formatting : 3.4. Formatting PL/SQL Blocks
  group : 6.13.1.1. Inefficiency of group functions in cursors
  headers of : 15.5.5. Function Header
  IN OUT and OUT parameters in : 22.2.1.1. Do not use OUT and IN OUT parameters
  for LOBs : 13.2. LOB Function Descriptions
  local
    15.7. Local Modules
    22.3. Take Full Advantage of Local Modularization
  miscellaneous : 13.3. Miscellaneous Function Descriptions
  names for : 1.7.5. Structured Code and Other Best Practices
  naming precedence : 17.6. Column/Function Name Precedence
  with NULL arguments : 4.3.3. Function Results with NULL Arguments
  numeric : 13. Numeric, LOB, and Miscellaneous Functions
  overloaded : 15.8.4. Restrictions on Overloading
  packaged : 17.5. Calling Packaged Functions in SQL
  parameters of : 15.6. Parameters
    without : 15.5.4.1. Functions without parameters
  PL/SQL, calling in SQL : 25.3.2. Call PL/SQL Functions in SQL to Reduce I/O
  records as parameters : 9.1.4. Guidelines for Using Records
  RETURN statement : 15.5.8. The RETURN Statement
  returned value of : 15.5.2. The RETURN Datatype
  returning objects : 18.1.2. Some Simple Examples
  returning tables from : 10.8.1.1. Referencing fields of record elements in PL/SQL tables
  shared : 23.1.2. Executing Functions
  tables as parameters for : 10.5.4. Passing PL/SQL Tables as Parameters
  template for : 22.2.2.1. Build a function template
  user information : 13.3.7. The UID function
  using single RETURN statement : 22.2.2. Use a Single RETURN Statement for Successful Termination
FX (format exact) modifier : 14.3.2. FX: Matching Formats Exactly

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.