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