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 : The FCLOSE procedure
• FCLOSE_ALL procedure : The FCLOSE_ALL procedure
• FETCH clause, assigning objects : Assignment via FETCH (with SELECT)
• FETCH INTO statement : FETCH INTO from an Explicit Cursor
• FETCH statement
• • (see also cursors)
  • The VARCHAR2 and VARCHAR datatypes
  • Cursor Operations
  • Fetching from Cursors
  • with cursor variables : Fetching from Cursor Variables
  • initializing collections : Initializing implicitly via fetch
• FETCH_ROW function : The FETCH_ROWS function
• fetching
• • from cursor variables : Fetching from Cursor Variables
  • from cursors : Fetching from Cursors
  • • checking status of FETCH : The %FOUND Attribute
  • to cursors, multiple times : Using multiple fetches more efficiently
• FFLUSH procedure : The FFLUSH procedure
• fields, record : (see records)
• FILECLOSE procedure : The FILECLOSE procedure
• FILECLOSEALL procedure : The FILECLOSEALL procedure
• FILEEXISTS function : The FILEEXISTS function
• FILEGETNAME procedure : The FILEGETNAME procedure
• FILEISOPEN function : The FILEISOPEN function
• filenames, encrypted file extensions : Working with Encrypted Code
• FILEOPEN procedure : The FILEOPEN procedure
• files
• • encrypted code, size of : Impact of Encrypting Code
  • operating system : UTL_FILE
  • for package specifications : Center All Development Around Packages
• filtering trace information : Filtering Trace Information
• FIRST function
• • The FIRST function
  • FIRST, LAST
• fixed-point numbers : Numeric Subtypes
• FLOAT subtype : Numeric Subtypes
• floating-point numbers : Numeric Subtypes
• FLOOR function : The FLOOR function
• FM (fill mode) modifier : FM: Suppressing Blanks and Zeros
• FOPEN function : The FOPEN function
• FOR loops
• • Write as Little Code as Possible
  • Structured Code and Other Best Practices
  • cursor
  • • The cursor FOR loop
    • The Cursor FOR Loop
  • formatting : Formatting Loops
  • numeric : The Numeric FOR Loop
  • premature termination of : Premature FOR loop termination
  • scope of : Scope in FOR loops
• FORCE parameter : CREATE TYPE and DROP TYPE: Creating and Dropping Types
• forced compilation : Forcing Compilation
• foreign key
• • lookups, optimizing in tables : Optimizing Foreign Key Lookups with PL/SQL Tables
  • object reference versus : Adding Complex Data Structures
  • validating entry of (example) : Validating Foreign Key Entry with Cursors
• formal parameters
• • Actual and Formal Parameters
  • naming : Develop Consistent Naming Conventions for Your Formal Parameters
• format
• • FM and FX modifiers : FM: Suppressing Blanks and Zeros
  • models : Conversion Formats
  • RR model : RR: Changing Millenia
  • verifying string : Verifying String Formats with TRANSLATE
• FORMAT_CALL_STACK function : The FORMAT_CALL_STACK function
• FORMAT_ERROR_STACK function : The FORMAT_ERROR_STACK function
• formatting code : Fundamentals of Effective Layout
• forward declarations : Forward Declarations
• forward type definitions : Forward type definitions
• %FOUND cursor attribute : The %FOUND Attribute
• free format trace filtering : Free Format Filtering
• functional abstraction : Abstraction
• functions
• • (see also modules)
  • Modular construction
  • Procedures and Functions
  • Functions
  • Make Sure the Module Name Explains the Module
  • Build the Most Functional Functions
  • built-in
  • • Built-in functions
    • Built-in functions
  • for characters, strings : Character Functions
  • for collections
  • • built-in : Collection Built-Ins
    • pseudo-functions : Collection Pseudo-Functions
  • collections as return values : Collections as the datatype of a function's return value
  • conversion : Conversion Functions
  • date and time : Date Functions
  • formatting : Formatting PL/SQL Blocks
  • group : Inefficiency of group functions in cursors
  • headers of : Function Header
  • IN OUT and OUT parameters in : Do not use OUT and IN OUT parameters
  • for LOBs : LOB Function Descriptions
  • local
  • • Local Modules
    • Take Full Advantage of Local Modularization
  • miscellaneous : Miscellaneous Function Descriptions
  • names for : Structured Code and Other Best Practices
  • naming precedence : Column/Function Name Precedence
  • with NULL arguments : Function Results with NULL Arguments
  • numeric : Numeric, LOB, and Miscellaneous Functions
  • overloaded : Restrictions on Overloading
  • packaged : Calling Packaged Functions in SQL
  • parameters of : Parameters
  • • without : Functions without parameters
  • PL/SQL, calling in SQL : Call PL/SQL Functions in SQL to Reduce I/O
  • records as parameters : Guidelines for Using Records
  • RETURN statement : The RETURN Statement
  • returned value of : The RETURN Datatype
  • returning objects : Some Simple Examples
  • returning tables from : Referencing fields of record elements in PL/SQL tables
  • shared : Executing Functions
  • tables as parameters for : Passing PL/SQL Tables as Parameters
  • template for : Build a function template
  • user information : The UID function
  • using single RETURN statement : Use a Single RETURN Statement for Successful Termination
• FX (format exact) modifier : FX: Matching Formats Exactly