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

Index: F

fanning out messages : (see broadcasting)

FCLOSE procedure

6.2.1.1. UTL_FILE programs

6.2.5.1. The UTL_FILE.FCLOSE procedure

FCLOSE_ALL procedure

6.2.1.1. UTL_FILE programs

6.2.5.2. The UTL_FILE.FCLOSE_ALL procedure

FETCH_ROWS function

2.2.3. DBMS_SQL Programs

2.3.7.1. The DBMS_SQL.FETCH_ROWS function

fetching rows : (see rows, fetching)

FFLUSH procedure

6.2.1.1. UTL_FILE programs

6.2.4.5. The UTL_FILE.FFLUSH procedure

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

file2tab.sp : 6.2.7.1. Enhancing UTL_FILE.GET_LINE

file_exists function : 6.2.7.3. Testing for a file's existence

file_to_table procedure : 6.2.7.1. Enhancing UTL_FILE.GET_LINE

FILECLOSE procedure

8.1.1. DBMS_LOB Programs

8.3.1.5. The DBMS_LOB.FILECLOSE procedure

FILECLOSEALL procedure

8.1.1. DBMS_LOB Programs

8.3.1.6. The DBMS_LOB.FILECLOSEALL procedure

fileexc.sql : 6.2.6.1. Handling file I/O errors

FILEEXISTS function

8.1.1. DBMS_LOB Programs

8.3.1.1. The DBMS_LOB.FILEEXISTS function

FILEGETNAME procedure

8.1.1. DBMS_LOB Programs

8.3.1.2. The DBMS_LOB.FILEGETNAME procedure

fileIO package

(see also specific program names)

6.2.6.3. Combining locations and filenames

6.2.6.4. Adding support for paths

FILEISOPEN function

8.1.1. DBMS_LOB Programs

8.3.1.4. The DBMS_LOB.FILEISOPEN function

FILEOPEN procedure

8.1.1. DBMS_LOB Programs

8.3.1.3. The DBMS_LOB.FILEOPEN procedure

filepath.spp : 6.2.6.4. Adding support for paths

filepath.tst : 6.2.6.4. Adding support for paths

files

(see also BFILEs; UTL_FILE package)

6.2. UTL_FILE: Reading and Writing Server-side Files

closing

all files : 6.2.5.2. The UTL_FILE.FCLOSE_ALL procedure

one file : 6.2.5.1. The UTL_FILE.FCLOSE procedure

unclosed files : 6.2.6.2. Closing unclosed files

deleting : 6.2.1.7. UTL_FILE restrictions and limitations

ROWIDs and : 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function

existence of (example) : 6.2.7.2. Creating a file

flushing data : 6.2.4.5. The UTL_FILE.FFLUSH procedure

handles

closing files and : 6.2.5.2. The UTL_FILE.FCLOSE_ALL procedure

I/O errors : 6.2.6.1. Handling file I/O errors

line length : 6.2.1.7. UTL_FILE restrictions and limitations

locating

6.2.1.4. Specifying file locations

6.2.6.3. Combining locations and filenames

mapped files : 6.2.1.7. UTL_FILE restrictions and limitations

opening : 6.2.2.1. The UTL_FILE.FOPEN function

random access : 6.2.1.7. UTL_FILE restrictions and limitations

example : 6.2.7.5. Getting the nth line from a file

read/write modes

6.2.2.1. The UTL_FILE.FOPEN function

6.2.4. Writing to Files

reading

6.2.1.8. The UTL_FILE process flow

6.2.3.1. The UTL_FILE.GET_LINE procedure

enhancing GET_LINE : 6.2.7.1. Enhancing UTL_FILE.GET_LINE

renaming : 6.2.1.7. UTL_FILE restrictions and limitations

searching (example) : 6.2.7.4. Searching a file for a string

security and UTL_FILE : 6.2.1.3. File security

string size maximum : 6.2.4. Writing to Files

testing if open

6.2.2.2. The UTL_FILE.IS_OPEN function

6.2.6.5. You closed what?

writing

6.2.1.8. The UTL_FILE process flow

6.2.4. Writing to Files

data : 6.2.4.1. The UTL_FILE.PUT procedure

data with newline marker : 6.2.4.3. The UTL_FILE.PUT_LINE procedure

formatted items : 6.2.4.4. The UTL_FILE.PUTF procedure

newline markers : 6.2.4.2. The UTL_FILE.NEW_LINE procedure

fileupd.sp : 2.5.6.3. Using array processing to update

filexist.sf : 6.2.7.3. Testing for a file's existence

fillblck.fp : 2.3.7.1. The DBMS_SQL.FETCH_ROWS function

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

FIRST_MESSAGE dequeuing : 5.4.2.5. Dequeue navigation

fixdefer.sql : 17.2.4.4. The DBMS_DEFER_SYS.EXECUTE_ERROR procedure

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

fkname.sf : 2.5.2. A Generic Foreign Key Lookup Function

fkname2.sf : 2.5.2. A Generic Foreign Key Lookup Function

fkname3.sf : 2.5.2. A Generic Foreign Key Lookup Function

FOPEN function

6.2.1.1. UTL_FILE programs

6.2.2.1. The UTL_FILE.FOPEN function

forcur procedure : 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS

foreign keys

obtaining description of (example) : 2.5.2. A Generic Foreign Key Lookup Function

VARCHAR2 in : 2.5.2. A Generic Foreign Key Lookup Function

format strings, PUTF and : 6.2.4.4. The UTL_FILE.PUTF procedure

FORMAT_CALL_STACK function

10.1.1. Getting Started with DBMS_UTILITY

10.1.2.10. The DBMS_UTILITY.FORMAT_CALL_STACK function

FORMAT_ERROR_STACK function

10.1.1. Getting Started with DBMS_UTILITY

10.1.2.11. The DBMS_UTILITY.FORMAT_ERROR_STACK function

forward procedure : 3.1.7.3. The dbpipe utility package

FREE_BLOCKS procedure : 12.1.2.1. The DBMS_SPACE.FREE_BLOCKS procedure

FREE_UNUSED_USER_MEMORY procedure

11.1.1.1. DBMS_SESSION programs

11.1.4.2. The DBMS_SESSION.FREE_UNUSED_USER_MEMORY procedure

freelist blocks, number available : 12.1.2.1. The DBMS_SPACE.FREE_BLOCKS procedure

freelist_blocks function : 12.1.3.1. The segspace package

function codes : 2.3.10.4. The DBMS_SQL.LAST_SQL_FUNCTION_CODE function

functions

describing : 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure

recompiling : 10.3.2. Compiling PL/SQL Objects

referencing in packages : 1.3.3. Referencing Built-in Package Elements

funnelling in messages : 5.1.4. Propagation Features

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