Book HomeBook HomeSearch this book

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
The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference