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

CD Home

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
login procedure
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

Copyright © 2000 O'Reilly & Associates, Inc. All rights reserved.