start page | rating of books | rating of authors | reviews | copyrights

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Index: F

%FOUND cursor attribute: 6.9.1. The %FOUND Attribute, Oracle PL/SQL Programming

FALSE: (see Boolean literals)

FCLOSE procedure

6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
6.2.5.1. The UTL_FILE.FCLOSE procedure, Oracle Built-in Packages
C.17.1.1. The FCLOSE procedure, Oracle PL/SQL Programming

FCLOSE_ALL procedure

6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
6.2.5.2. The UTL_FILE.FCLOSE_ALL procedure, Oracle Built-in Packages
C.17.1.2. The FCLOSE_ALL procedure, Oracle PL/SQL Programming

FETCH INTO clause

5.3. Bulk Querying with the BULK COLLECT Clause, Guide to Oracle8i Features
: 9.5.3. FETCH INTO from an Explicit Cursor, Oracle PL/SQL Programming

FETCH clause

assigning objects: 18.4.1.3. Assignment via FETCH (with SELECT), Oracle PL/SQL Programming

FETCH statement

(see also cursors)
4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming
6.2.2. Cursor Operations, Oracle PL/SQL Programming
6.6. Fetching from Cursors, Oracle PL/SQL Programming
initializing collections: 19.4.1.3. Initializing implicitly via fetch, Oracle PL/SQL Programming
with cursor variables: 6.12.5. Fetching from Cursor Variables, Oracle PL/SQL Programming

FETCH statement, native dynamic SQL: 4.3.1. FETCH into Variables or Records, Guide to Oracle8i Features

FETCH_ROWS function

C.14.8. The FETCH_ROWS function, Oracle PL/SQL Programming
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.7.1. The DBMS_SQL.FETCH_ROWS function, Oracle Built-in Packages

FFLUSH procedure

6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
6.2.4.5. The UTL_FILE.FFLUSH procedure, Oracle Built-in Packages
C.17.1.3. The FFLUSH procedure, Oracle PL/SQL Programming

FGAC (fine-grained access control)

7.3. DBMS_RLS: Implementing Fine-Grained Access Control, Guide to Oracle8i Features
1.3.7. Fine-Grained Access Control (Chapter 8, Deploying Fine-Grained Access Control), Guide to Oracle8i Features
LOGON triggers, setting up,: 8.5.5. Setting Up the LOGON Trigger, Guide to Oracle8i Features
components: 8.1. FGAC Components, Guide to Oracle8i Features
context attribute values, setting: 8.3. SET_CONTEXT: Setting Context and Attribute Values, Guide to Oracle8i Features
context data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
context for schema, setting: 8.5.2. Setting the Context for the Schema, Guide to Oracle8i Features
context information, obtaining: 8.4. SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information, Guide to Oracle8i Features
creating contexts: 8.2. CREATE CONTEXT: Creating Contexts, Guide to Oracle8i Features
debugging: 8.5.6. Debugging FGAC Code, Guide to Oracle8i Features
example: 8.5. A Complete FGAC Example, Guide to Oracle8i Features
list of defined context attributes, obtaining: 8.4.2. LIST_CONTEXT: Obtaining the List of Defined Context Attributes, Guide to Oracle8i Features
overview: 8. Deploying Fine-Grained Access Control, Guide to Oracle8i Features
policies, defining: 8.5.4. Defining the Policy , Guide to Oracle8i Features
predicates, defining: 8.5.3. Defining the Predicate, Guide to Oracle8i Features
security packages, creatinging: 8.5.1. Creating the Security Package, Guide to Oracle8i Features

FILECLOSE procedure

8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.1.5. The DBMS_LOB.FILECLOSE procedure, Oracle Built-in Packages
C.6.5. The FILECLOSE procedure, Oracle PL/SQL Programming

FILECLOSEALL procedure

8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.1.6. The DBMS_LOB.FILECLOSEALL procedure, Oracle Built-in Packages
C.6.6. The FILECLOSEALL procedure, Oracle PL/SQL Programming

FILEEXISTS function

8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.1.1. The DBMS_LOB.FILEEXISTS function, Oracle Built-in Packages
C.6.7. The FILEEXISTS function, Oracle PL/SQL Programming

FILEGETNAME procedure

8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.1.2. The DBMS_LOB.FILEGETNAME procedure, Oracle Built-in Packages
C.6.8. The FILEGETNAME procedure, Oracle PL/SQL Programming

FILEISOPEN function

8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.1.4. The DBMS_LOB.FILEISOPEN function, Oracle Built-in Packages
C.6.9. The FILEISOPEN function , Oracle PL/SQL Programming
8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.1.3. The DBMS_LOB.FILEOPEN procedure, Oracle Built-in Packages
C.6.10. The FILEOPEN procedure, Oracle PL/SQL Programming

FILE_TYPE datatype: 13.1.2. File Handles, Advanced Oracle PL/SQL Programming with Packages

FIRST function

10.8.2.4. The FIRST function, Oracle PL/SQL Programming
19.6.5. FIRST, LAST, Oracle PL/SQL Programming

FIRST_MESSAGE dequeuing: 5.4.2.5. Dequeue navigation, Oracle Built-in Packages

FLOAT subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming

FLOOR function: 13.1.10. The FLOOR function, Oracle PL/SQL Programming

FM (fill mode) modifier: 14.3.1. FM: Suppressing Blanks and Zeros, Oracle PL/SQL Programming

FOPEN function

6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
6.2.2.1. The UTL_FILE.FOPEN function, Oracle Built-in Packages
C.17.1.4. The FOPEN function, Oracle PL/SQL Programming

FOR UPDATE: 4.5. Working with Objects and Collections, Guide to Oracle8i Features

FOR loops

6.2.4. Loops, Oracle Web Applications

1.3.4. Bulk Binds and Collects (Chapter 5, Bulking Up with PL/SQL 8.1), Guide to Oracle8i Features

5.3.3. Using the RETURNING Clause with Bulk Operations, Guide to Oracle8i Features

5.5. Analyzing the Impact of Bulk Operations, Guide to Oracle8i Features

7.4. UTL_COLL: Using Collection Locators, Guide to Oracle8i Features

1.7.1. Write as Little Code as Possible, Oracle PL/SQL Programming

1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming

cursor

16.2.8. Generating a Cursor FOR Loop, Advanced Oracle PL/SQL Programming with Packages
11.7. A Programmatic Cursor FOR Loop, Advanced Oracle PL/SQL Programming with Packages
1.6.4. The cursor FOR loop, Oracle PL/SQL Programming
7.4. The Cursor FOR Loop, Oracle PL/SQL Programming

formatting: 3.3.2. Formatting Loops, Oracle PL/SQL Programming

numeric: 7.3. The Numeric FOR Loop, Oracle PL/SQL Programming

premature termination of: 7.7.2.1. Premature FOR loop termination, Oracle PL/SQL Programming

scope of: 7.6.2.1. Scope in FOR loops, Oracle PL/SQL Programming

FORALL statement

5.2. Bulk DML with the FORALL Statement, Guide to Oracle8i Features
1.3.4. Bulk Binds and Collects (Chapter 5, Bulking Up with PL/SQL 8.1), Guide to Oracle8i Features
5.5. Analyzing the Impact of Bulk Operations, Guide to Oracle8i Features
5. Bulking Up with PL/SQL 8.1, Guide to Oracle8i Features
5.3.3. Using the RETURNING Clause with Bulk Operations, Guide to Oracle8i Features

FORCE parameter: 18.3.2. CREATE TYPE and DROP TYPE: Creating and Dropping Types, Oracle PL/SQL Programming

FORMAT_CALL_STACK function

21.2.2. Accessing the PL/SQL Call Stack, Advanced Oracle PL/SQL Programming with Packages
10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.10. The DBMS_UTILITY.FORMAT_CALL_STACK function, Oracle Built-in Packages
C.16.4. The FORMAT_CALL_STACK function, Oracle PL/SQL Programming

FORMAT_ERROR_STACK function

10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.11. The DBMS_UTILITY.FORMAT_ERROR_STACK function, Oracle Built-in Packages
C.16.5. The FORMAT_ERROR_STACK function, Oracle PL/SQL Programming

FORTRAN: 1.2.2. Application Development, Oracle Web Applications

FORUM package: 8.3.3. Implementation Notes, Oracle Web Applications

create_msg_form procedure

8.3.6. The FORUM Package, Oracle Web Applications
8.3.6.2. Body, Oracle Web Applications

save_message procedure

8.3.6. The FORUM Package, Oracle Web Applications
8.3.6.2. Body, Oracle Web Applications

view_message procedure

8.3.6. The FORUM Package, Oracle Web Applications
8.3.6.2. Body, Oracle Web Applications

current_forum_list procedure

8.3.6. The FORUM Package, Oracle Web Applications
8.3.6.2. Body, Oracle Web Applications

print_thread_links procedure

8.3.6. The FORUM Package, Oracle Web Applications
8.3.6.2. Body, Oracle Web Applications

FORUM_USERS package

8.3.3. Implementation Notes, Oracle Web Applications

8.3.5. The FORUM_USERS Package, Oracle Web Applications

create_user_form

8.3.5. The FORUM_USERS Package, Oracle Web Applications
8.3.5.2. Body, Oracle Web Applications

get_current_user

8.3.5. The FORUM_USERS Package, Oracle Web Applications
8.3.5.2. Body, Oracle Web Applications

8.3.5. The FORUM_USERS Package, Oracle Web Applications
8.3.5.2. Body, Oracle Web Applications

login_form procedure

8.3.5. The FORUM_USERS Package, Oracle Web Applications
8.3.5.2. Body, Oracle Web Applications

save_user_info

8.3.5. The FORUM_USERS Package, Oracle Web Applications
8.3.5.2. Body, Oracle Web Applications

FREETEMPORARY procedure, DBMS_LOB package: 7.5.2.2. FREETEMPORARY: Freeing the temporary LOB, Guide to Oracle8i Features

FREE_BLOCKS procedure: 12.1.2.1. The DBMS_SPACE.FREE_BLOCKS procedure, Oracle Built-in Packages

FREE_UNUSED_USER_MEMORY procedure

11.1.1.1. DBMS_SESSION programs , Oracle Built-in Packages
11.1.4.2. The DBMS_SESSION.FREE_UNUSED_USER_MEMORY procedure, Oracle Built-in Packages

FROG (Funky Resource for Oracle Gorillas): 6.4. PL/SQL Tools, Oracle Web Applications

FTP: 1.3.1. The Internet File System, Oracle Web Applications

FUNCTION column, *_POLICIES data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features

FX (format exact) modifier: 14.3.2. FX: Matching Formats Exactly, Oracle PL/SQL Programming

FrontPage: 1.3.9.2. Multimedia data, Oracle Web Applications

factor function

5.27.3. Setting the factoring value, Advanced Oracle PL/SQL Programming with Packages
14.3.3. Setting the Timing Factor, Advanced Oracle PL/SQL Programming with Packages

fast refresh: 1.3.8.2. EnterpriseSync Lite, Oracle Web Applications

fclose procedure

5.11.8. Closing a file, Advanced Oracle PL/SQL Programming with Packages
5.17.6. Managing the log , Advanced Oracle PL/SQL Programming with Packages
13.4. Opening and Closing Files, Advanced Oracle PL/SQL Programming with Packages
21.1.3.2. Closing the file, Advanced Oracle PL/SQL Programming with Packages

fclose_all procedure

5.11.8. Closing a file, Advanced Oracle PL/SQL Programming with Packages
13.4. Opening and Closing Files, Advanced Oracle PL/SQL Programming with Packages

fcopy procedure

5.11.11. Copying a file, Advanced Oracle PL/SQL Programming with Packages
13.7.1. Copying File to File, Advanced Oracle PL/SQL Programming with Packages

fcreate function

5.11.5. Creating files, Advanced Oracle PL/SQL Programming with Packages
13.3. Creating and Checking Existence of Files, Advanced Oracle PL/SQL Programming with Packages

fetch_object procedure

5.20.5. Interfacing with the PLVobj cursor, Advanced Oracle PL/SQL Programming with Packages
11.4.2. Fetching from the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages

fetching

from cursor variables: 6.12.5. Fetching from Cursor Variables, Oracle PL/SQL Programming

from cursors: 6.6. Fetching from Cursors, Oracle PL/SQL Programming

checking status of FETCH: 6.9.1. The %FOUND Attribute, Oracle PL/SQL Programming

from PLVobj cursor: 11.4.2. Fetching from the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages

rows: (see rows, fetching)

to cursors, multiple times: 6.13.1.2. Using multiple fetches more efficiently , Oracle PL/SQL Programming

fexists function

5.11.6. Checking for file existence, Advanced Oracle PL/SQL Programming with Packages
13.3.1. Checking a File's Existence, Advanced Oracle PL/SQL Programming with Packages

fgac.sql file: 8.5. A Complete FGAC Example, Guide to Oracle8i Features

fields, record: (see records)

fifo constant: 5.24.1. Package constants, Advanced Oracle PL/SQL Programming with Packages

file attributes: 1.2.1.1. Finding what you need, Oracle Web Applications

file constant: 5.3.1. PL/Vision constants, Advanced Oracle PL/SQL Programming with Packages

file extensions: 3.2.3.3. MIME type mappings, Oracle Web Applications

file handles: 13.1.2. File Handles, Advanced Oracle PL/SQL Programming with Packages

file numbers: (see absolute file numbers; data block addresses; relative file numbers)

file, WebDB dashboard: 3.1.3.1. User-uploaded content, Oracle Web Applications

file2list procedure

5.11.11. Copying a file, Advanced Oracle PL/SQL Programming with Packages
13.7.3. Copying File to List, Advanced Oracle PL/SQL Programming with Packages

file2pstab procedure

5.11.11. Copying a file, Advanced Oracle PL/SQL Programming with Packages
13.7.2. Copying File to PL/SQL Table, Advanced Oracle PL/SQL Programming with Packages

file2tab.sp : 6.2.7.1. Enhancing UTL_FILE.GET_LINE, Oracle Built-in Packages

fileIO package

(see also specific program names)
6.2.6.3. Combining locations and filenames, Oracle Built-in Packages
6.2.6.4. Adding support for paths, Oracle Built-in Packages

file_exists function: 6.2.7.3. Testing for a file's existence, Oracle Built-in Packages

file_to_table procedure: 6.2.7.1. Enhancing UTL_FILE.GET_LINE, Oracle Built-in Packages

fileexc.sql : 6.2.6.1. Handling file I/O errors, Oracle Built-in Packages

filenames, encrypted file extensions: 23.7.2. Working with Encrypted Code, Oracle PL/SQL Programming

filepath.spp : 6.2.6.4. Adding support for paths, Oracle Built-in Packages

filepath.tst : 6.2.6.4. Adding support for paths, Oracle Built-in Packages

files

(see also BFILEs; UTL_FILE package)

13. PLVfile: Reading and Writing Operating System Files, Advanced Oracle PL/SQL Programming with Packages

6.2. UTL_FILE: Reading and Writing Server-side Files, Oracle Built-in Packages

I/O errors: 6.2.6.1. Handling file I/O errors, Oracle Built-in Packages

as code repository: 12.2.5. Standard Output Target, Advanced Oracle PL/SQL Programming with Packages

checking for existence of

5.11.6. Checking for file existence, Advanced Oracle PL/SQL Programming with Packages
13.3. Creating and Checking Existence of Files, Advanced Oracle PL/SQL Programming with Packages

closing: 21.1.3.2. Closing the file, Advanced Oracle PL/SQL Programming with Packages

all files: 6.2.5.2. The UTL_FILE.FCLOSE_ALL procedure, Oracle Built-in Packages

one file: 6.2.5.1. The UTL_FILE.FCLOSE procedure, Oracle Built-in Packages

unclosed files: 6.2.6.2. Closing unclosed files, Oracle Built-in Packages

copying

5.11.11. Copying a file, Advanced Oracle PL/SQL Programming with Packages
13.7. Copying File Contents, Advanced Oracle PL/SQL Programming with Packages

created during installation: 4.6. Summary of Files on Disk, Advanced Oracle PL/SQL Programming with Packages

creating: 5.11.5. Creating files, Advanced Oracle PL/SQL Programming with Packages

deleting: 6.2.1.7. UTL_FILE restrictions and limitations, Oracle Built-in Packages

ROWIDs and: 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function, Oracle Built-in Packages

encrypted code, size of: 23.7.3. Impact of Encrypting Code, Oracle PL/SQL Programming

existence of (example): 6.2.7.2. Creating a file, Oracle Built-in Packages

file errors: 13.9. Handling File Errors with PLVfile, Advanced Oracle PL/SQL Programming with Packages

filenames: 13.1.3. File Location, Name, and Mode, Advanced Oracle PL/SQL Programming with Packages

flushing data: 6.2.4.5. The UTL_FILE.FFLUSH procedure, Oracle Built-in Packages

for package specifications: 1.7.3. Center All Development Around Packages, Oracle PL/SQL Programming

handles, closing files and: 6.2.5.2. The UTL_FILE.FCLOSE_ALL procedure, Oracle Built-in Packages

line length: 6.2.1.7. UTL_FILE restrictions and limitations, Oracle Built-in Packages

locating

6.2.1.4. Specifying file locations, Oracle Built-in Packages
6.2.6.3. Combining locations and filenames, Oracle Built-in Packages

log: 21.1.3. Selecting the Log Type, Advanced Oracle PL/SQL Programming with Packages

logging: (see logging)

mapped files: 6.2.1.7. UTL_FILE restrictions and limitations, Oracle Built-in Packages

name extensions: 2.4. Organizing Package Source Code, Advanced Oracle PL/SQL Programming with Packages

opening and closing

A HREF="../ch06_02.htm#ch06-SECT-2.2.1">6.2.2.1. The UTL_FILE.FOPEN function, Oracle Built-in Packages
5.11.7. Opening a file, Advanced Oracle PL/SQL Programming with Packages
13.4. Opening and Closing Files, Advanced Oracle PL/SQL Programming with Packages

operating system: C.17. UTL_FILE, Oracle PL/SQL Programming

parsing name of: 5.11.13. Miscellaneous operations, Advanced Oracle PL/SQL Programming with Packages

random access: 6.2.1.7. UTL_FILE restrictions and limitations, Oracle Built-in Packages

example: 6.2.7.5. Getting the nth line from a file, Oracle Built-in Packages

read/write modes

6.2.2.1. The UTL_FILE.FOPEN function, Oracle Built-in Packages
6.2.4. Writing to Files, Oracle Built-in Packages

reading from

6.2.1.8. The UTL_FILE process flow, Oracle Built-in Packages
6.2.3.1. The UTL_FILE.GET_LINE procedure, Oracle Built-in Packages
enhancing GET_LINE: 6.2.7.1. Enhancing UTL_FILE.GET_LINE, Oracle Built-in Packages
13.5. Reading From a File, Advanced Oracle PL/SQL Programming with Packages
5.11.9. Reading from a file, Advanced Oracle PL/SQL Programming with Packages

renaming: 6.2.1.7. UTL_FILE restrictions and limitations, Oracle Built-in Packages

searching (example): 6.2.7.4. Searching a file for a string, Oracle Built-in Packages

security and UTL_FILE: 6.2.1.3. File security, Oracle Built-in Packages

string size maximum: 6.2.4. Writing to Files, Oracle Built-in Packages

testing if open

6.2.2.2. The UTL_FILE.IS_OPEN function, Oracle Built-in Packages
6.2.6.5. You closed what?, Oracle Built-in Packages

writing to

13.6. Writing to a File, Advanced Oracle PL/SQL Programming with Packages

6.2.1.8. The UTL_FILE process flow, Oracle Built-in Packages

6.2.4. Writing to Files, Oracle Built-in Packages

data: 6.2.4.1. The UTL_FILE.PUT procedure, Oracle Built-in Packages

data with newline marker: 6.2.4.3. The UTL_FILE.PUT_LINE procedure, Oracle Built-in Packages

formatted items: 6.2.4.4. The UTL_FILE.PUTF procedure, Oracle Built-in Packages

newline markers: 6.2.4.2. The UTL_FILE.NEW_LINE procedure, Oracle Built-in Packages

filesystems: 1.2.1.1. Finding what you need, Oracle Web Applications

fileupd.sp : 2.5.6.3. Using array processing to update, Oracle Built-in Packages

filexist.sf : 6.2.7.3. Testing for a file's existence, Oracle Built-in Packages

fillblck.fp : 2.3.7.1. The DBMS_SQL.FETCH_ROWS function, Oracle Built-in Packages

filtering trace information: 26.2.3. Filtering Trace Information, Oracle PL/SQL Programming

finding

Record Found? function: 16.2.7. Generating a "Record Found?" Function, Advanced Oracle PL/SQL Programming with Packages
foreign key names: 19.6.3. Looking Up the Name, Advanced Oracle PL/SQL Programming with Packages
help text: 17.5.2. Locating Text in the Data Dictionary, Advanced Oracle PL/SQL Programming with Packages
source code: 15.4.1. How to Find Source Code, Advanced Oracle PL/SQL Programming with Packages

firewalls: 2.5.5. Additional Security Precautions, Oracle Web Applications

first-in-first-out queues: (see queues)

fixdefer.sql : 17.2.4.4. The DBMS_DEFER_SYS.EXECUTE_ERROR procedure, Oracle Built-in Packages

fixed-point numbers: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming

fixed-width character sets: (see CLOBs; NCLOBs)

fixes, code: 1.6.1.6. Hide weaknesses to facilitate upgrades and fixes., Advanced Oracle PL/SQL Programming with Packages

fkname.sf : 2.5.2. A Generic Foreign Key Lookup Function, Oracle Built-in Packages

fkname2.sf : 2.5.2. A Generic Foreign Key Lookup Function, Oracle Built-in Packages

fkname3.sf : 2.5.2. A Generic Foreign Key Lookup Function, Oracle Built-in Packages

fky procedure: 5.8.3. Dumping the DDL, Advanced Oracle PL/SQL Programming with Packages

flags, OWA_PATTERN package: 7.2.2.1. Regular expressions, Oracle Web Applications

flexibility

2.5.1. Seeing Developers as Users, Advanced Oracle PL/SQL Programming with Packages
2.6. Building Flexibility Into Your Packages, Advanced Oracle PL/SQL Programming with Packages
2.10. Hiding Package Data, Advanced Oracle PL/SQL Programming with Packages
16.4.3.1. Flexibility of put_line, Advanced Oracle PL/SQL Programming with Packages
logging: 21.1.3. Selecting the Log Type, Advanced Oracle PL/SQL Programming with Packages
transaction processing: 20.1.1. Who Needs PLVcmt?, Advanced Oracle PL/SQL Programming with Packages

floating-point numbers: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming

folder

default: 13.2.2. Setting the Default Directory, Advanced Oracle PL/SQL Programming with Packages
PL/Vision: 4.3.3. Beginning the Installation, Advanced Oracle PL/SQL Programming with Packages
setting default: 5.11.4. Setting the default directory or location, Advanced Oracle PL/SQL Programming with Packages

folderlink, WebDB dashboard: 3.1.3.1. User-uploaded content, Oracle Web Applications

folders, WebDB: 3.1.3.2. Managing content, Oracle Web Applications

fonts library, WebDB: 3.1.2.3. Building shared components, Oracle Web Applications

fopen procedure

5.11.7. Opening a file, Advanced Oracle PL/SQL Programming with Packages
13.4. Opening and Closing Files, Advanced Oracle PL/SQL Programming with Packages

forallerr.sql file: 5.2.2. ROLLBACK Behavior with FORALL, Guide to Oracle8i Features

forced compilation: 20.7.3. Forcing Compilation, Oracle PL/SQL Programming

forcur procedure: 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages

foreign keys

information: 5.12. PLVfk: Foreign Key Interface, Advanced Oracle PL/SQL Programming with Packages
object reference versus: 18.2.3. Adding Complex Data Structures, Oracle PL/SQL Programming
obtaining description of (example): 2.5.2. A Generic Foreign Key Lookup Function, Oracle Built-in Packages
validating entry of (example): 6.13.1. Validating Foreign Key Entry with Cursors, Oracle PL/SQL Programming
VARCHAR2 in: 2.5.2. A Generic Foreign Key Lookup Function, Oracle Built-in Packages

foreign key lookup

19.6. PLVfk: Generic Foreign Key Lookups, Advanced Oracle PL/SQL Programming with Packages
A.1.8. Module Evaluation: Foreign Key Lookup, Advanced Oracle PL/SQL Programming with Packages
A.2.8. Module Evaluation: Foreign Key Lookup, Advanced Oracle PL/SQL Programming with Packages
optimizing in tables: 10.9.5. Optimizing Foreign Key Lookups with PL/SQL Tables, Oracle PL/SQL Programming

form page wizard, WebDB: 3.1.2.2. Building user interface components , Oracle Web Applications

formal parameters

6.1.3. Parameters, Oracle Web Applications
15.6.3. Actual and Formal Parameters, Oracle PL/SQL Programming
naming: 22.1.2. Develop Consistent Naming Conventions for Your Formal Parameters , Oracle PL/SQL Programming

format

FM and FX modifiers: 14.3.1. FM: Suppressing Blanks and Zeros, Oracle PL/SQL Programming
RR model: 14.3.3. RR: Changing Millenia, Oracle PL/SQL Programming
date: (see date and time)
help text: 17.4.3. Creating Help Text, Advanced Oracle PL/SQL Programming with Packages
models: 14.1. Conversion Formats, Oracle PL/SQL Programming
verifying string: 11.2.5. Verifying String Formats with TRANSLATE, Oracle PL/SQL Programming

format strings, PUTF and: 6.2.4.4. The UTL_FILE.PUTF procedure, Oracle Built-in Packages

formatting code

5.13. PLVgen: PL/SQL Code Generator, Advanced Oracle PL/SQL Programming with Packages
3.1. Fundamentals of Effective Layout, Oracle PL/SQL Programming

forms, HTML: 2.4.3.2. Using an HTML form, Oracle Web Applications

forums, creating as web applications: 8.3. Example 2: A Discussion Forum, Oracle Web Applications

forward declarations: 15.9. Forward Declarations, Oracle PL/SQL Programming

forward procedure: 3.1.7.3. The dbpipe utility package, Oracle Built-in Packages

forward type definitions: 18.3.5.1. Forward type definitions, Oracle PL/SQL Programming

frame driver page wizard, WebDB: 3.1.2.2. Building user interface components , Oracle Web Applications

free format trace filtering: 26.3. Free Format Filtering, Oracle PL/SQL Programming

freelist blocks, number available: 12.1.2.1. The DBMS_SPACE.FREE_BLOCKS procedure, Oracle Built-in Packages

freelist_blocks function: 12.1.3.1. The segspace package, Oracle Built-in Packages

fullname function: 5.20.4. Accessing the current object, Advanced Oracle PL/SQL Programming with Packages

func procedure

5.13.8. Generating functions, Advanced Oracle PL/SQL Programming with Packages
5.27.6. Calibration and timing scripts, Advanced Oracle PL/SQL Programming with Packages
14.4.2. Calculating Overhead of an Action, Advanced Oracle PL/SQL Programming with Packages
16.2.3. Generating a Function, Advanced Oracle PL/SQL Programming with Packages
16.4.4. Overloading in PLVgen, Advanced Oracle PL/SQL Programming with Packages

function codes: 2.3.10.4. The DBMS_SQL.LAST_SQL_FUNCTION_CODE function, Oracle Built-in Packages

function wizard, WebDB: 3.1.2.1. Building database objects, Oracle Web Applications

function_schema parameter, ADD_POLICY procedure: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features

functional abstraction: 18.1.5.3. Abstraction , Oracle PL/SQL Programming

functions

(see also under specific function name, modules)

A.1.5. Builtin Functions, Advanced Oracle PL/SQL Programming with Packages

1.6.5. Calling Packaged Functions in SQL, Advanced Oracle PL/SQL Programming with Packages

3.6. Building a Structured Function, Advanced Oracle PL/SQL Programming with Packages

5.13.8. Generating functions, Advanced Oracle PL/SQL Programming with Packages

1.4.3.10. Modular construction, Oracle PL/SQL Programming

15. Procedures and Functions, Oracle PL/SQL Programming

15.5. Functions, Oracle PL/SQL Programming

22.1.1. Make Sure the Module Name Explains the Module, Oracle PL/SQL Programming

22.2. Build the Most Functional Functions, Oracle PL/SQL Programming

IN OUT and OUT parameters in: 22.2.1.1. Do not use OUT and IN OUT parameters, Oracle PL/SQL Programming

PL/SQL, calling in SQL: 25.3.2. Call PL/SQL Functions in SQL to Reduce I/O, Oracle PL/SQL Programming

PLV package: 6. PLV: Top-Level Constants and Functions , Advanced Oracle PL/SQL Programming with Packages

RETURN statement: 15.5.8. The RETURN Statement, Oracle PL/SQL Programming

avoiding ambiguous arguments: 2.8.1.3. Unambiguous, simple arguments, Advanced Oracle PL/SQL Programming with Packages

built-in

A.2.5. Builtin Functions, Advanced Oracle PL/SQL Programming with Packages
1.4.3.5. Built-in functions , Oracle PL/SQL Programming
1.6.2. Built-in functions, Oracle PL/SQL Programming

collections as return values: 19.2.2.4. Collections as the datatype of a function's return value, Oracle PL/SQL Programming

conversion: 14. Conversion Functions, Oracle PL/SQL Programming

date and time: 12. Date Functions, Oracle PL/SQL Programming

describing: 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure, Oracle Built-in Packages

for LOBs: 13.2. LOB Function Descriptions, Oracle PL/SQL Programming

for characters, strings: 11. Character Functions, Oracle PL/SQL Programming

for collections

built-in: 19.6. Collection Built-Ins, Oracle PL/SQL Programming

pseudo-functions: 19.5. Collection Pseudo-Functions, Oracle PL/SQL Programming

formatting: 3.4. Formatting PL/SQL Blocks, Oracle PL/SQL Programming

generating: 16.2.3. Generating a Function, Advanced Oracle PL/SQL Programming with Packages

group: 6.13.1.1. Inefficiency of group functions in cursors, Oracle PL/SQL Programming

headers of: 15.5.5. Function Header, Oracle PL/SQL Programming

local

15.7. Local Modules, Oracle PL/SQL Programming
22.3. Take Full Advantage of Local Modularization, Oracle PL/SQL Programming

miscellaneous: 13.3. Miscellaneous Function Descriptions, Oracle PL/SQL Programming

names for: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming

naming: 2.3.1. Choosing Appropriate and Accurate Names, Advanced Oracle PL/SQL Programming with Packages

naming precedence: 17.6. Column/Function Name Precedence, Oracle PL/SQL Programming

numeric: 13. Numeric, LOB, and Miscellaneous Functions, Oracle PL/SQL Programming

overloaded: 15.8.4. Restrictions on Overloading, Oracle PL/SQL Programming

packaged: 17.5. Calling Packaged Functions in SQL, Oracle PL/SQL Programming

parameters of: 15.6. Parameters, Oracle PL/SQL Programming

without: 15.5.4.1. Functions without parameters, Oracle PL/SQL Programming

PL/SQL: 6.1.2. Functions, Oracle Web Applications

recompiling: 10.3.2. Compiling PL/SQL Objects, Oracle Built-in Packages

records as parameters: 9.1.4. Guidelines for Using Records, Oracle PL/SQL Programming

referencing in packages: 1.3.3. Referencing Built-in Package Elements, Oracle Built-in Packages

returned value of: 15.5.2. The RETURN Datatype, Oracle PL/SQL Programming

returning objects: 18.1.2. Some Simple Examples, Oracle PL/SQL Programming

returning tables from: 10.8.1.1. Referencing fields of record elements in PL/SQL tables, Oracle PL/SQL Programming

scope of: 3.8. Broadening the Scope, Advanced Oracle PL/SQL Programming with Packages

shared: 23.1.2. Executing Functions, Oracle PL/SQL Programming

tables as parameters for: 10.5.4. Passing PL/SQL Tables as Parameters, Oracle PL/SQL Programming

template for: 22.2.2.1. Build a function template, Oracle PL/SQL Programming

user information: 13.3.7. The UID function, Oracle PL/SQL Programming

using single RETURN statement: 22.2.2. Use a Single RETURN Statement for Successful Termination, Oracle PL/SQL Programming

with NULL arguments: 4.3.3. Function Results with NULL Arguments, Oracle PL/SQL Programming

funnelling in messages: 5.1.4. Propagation Features, Oracle Built-in Packages

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z