Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)

Part Number A88879-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

External LOBs (BFILEs), 2 of 41


Use Case Model: External LOBs (BFILEs)

Table 12-1, "Use Case Model: External LOBs (BFILEs)", indicates with + where examples are provided for specific use cases and in which programmatic environment (see Chapter 3, "LOB Support in Different Programmatic Environments" for a complete discussion and references to related manuals).

Programmatic environment abbreviations used in the following table, are as follows:

Table 12-1 Use Case Model: External LOBs (BFILEs)

Use Case and Page    Programmatic Environment Examples 
  P  O  B  C  V  J 

Three Ways to Create a Table Containing a BFILE  

 

 

 

 

 

 

Creating a Table Containing One or More BFILE Columns  

S 

S 

S 

S 

S 

S 

Creating a Table of an Object Type with a BFILE Attribute

 

S 

S 

S 

S 

S 

S 

Creating a Table with a Nested Table Containing a BFILE

 

S 

S 

S 

S 

S 

S 

Three Ways to Insert a Row Containing a BFILE  

 

 

 

 

 

 

INSERT a Row Using BFILENAME()  

S 

+ 

+ 

+ 

+ 

+ 

INSERT a BFILE Row by Selecting a BFILE From Another Table  

S 

S 

S 

S 

S 

S 

Inserting a Row With BFILE by Initializing a BFILE Locator  

+ 

+ 

+ 

+ 

+ 

+ 

Loading Data Into External LOB (BFILE)  

S 

S 

S 

S 

S 

S 

Loading a LOB with BFILE Data  

+ 

+ 

+ 

+ 

+ 

+ 

Two Ways to Open a BFILE  

 

 

 

 

 

 

Opening a BFILE with FILEOPEN  

+ 

+ 

 

 

 

+ 

Opening a BFILE with OPEN  

+ 

+ 

+ 

+ 

+ 

+ 

Two Ways to See If a BFILE is Open  

 

 

 

 

 

 

Checking If the BFILE is Open with FILEISOPEN  

+ 

+ 

 

 

 

+ 

Checking If a BFILE is Open Using ISOPEN  

+ 

+ 

+ 

+ 

+ 

+ 

Displaying BFILE Data

+ 

+ 

+ 

+ 

+ 

+ 

Reading Data from a BFILE

+ 

+ 

+ 

+ 

+ 

+ 

Reading a Portion of BFILE Data (substr)  

+ 

 

+ 

+ 

+ 

+ 

Comparing All or Parts of Two BFILES  

+ 

 

+ 

+ 

+ 

+ 

Checking If a Pattern Exists (instr) in the BFILE  

+ 

 

+ 

+ 

 

+ 

Checking If the BFILE Exists 

+ 

+ 

+ 

+ 

+ 

+ 

Getting the Length of a BFILE  

+ 

+ 

+ 

+ 

+ 

+ 

Copying a LOB Locator for a BFILE  

+ 

+ 

+ 

+ 

 

+ 

Determining If a LOB Locator for a BFILE Is Initialized  

 

+ 

 

+ 

 

 

Determining If One LOB Locator for a BFILE Is Equal to Another  

 

+ 

 

+ 

 

+ 

Getting DIRECTORY Alias and Filename

+ 

+ 

+ 

+ 

+ 

+ 

Three Ways to Update a Row Containing a BFILE  

 

 

 

 

 

 

Updating a BFILE Using BFILENAME()  

S 

S 

S 

S 

S 

S 

Updating a BFILE by Selecting a BFILE From Another Table  

S 

S 

S 

S 

S 

S 

Updating a BFILE by Initializing a BFILE Locator  

+ 

+ 

+ 

+ 

+ 

+ 

Two Ways to Close a BFILE  

 

 

 

 

 

 

Closing a BFILE with FILECLOSE

+ 

+ 

 

 

+ 

+ 

Closing a BFILE with CLOSE  

+ 

+ 

+ 

+ 

+ 

+ 

Closing All Open BFILEs with FILECLOSEALL  

+ 

+ 

+ 

+ 

+ 

+ 

Deleting the Row of a Table Containing a BFILE  

S 

S 

S 

S 

S 

S 

Figure 12-1 Use Case Model Diagram: External LOBs (BFILEs)


Text description of adl12bf3.gif follows This link takes you to section Deleting the Row of a Table Containing a BFILE. This link takes you to section Loading Initial Data into External LOB (BFILE). This link takes you to section Two Ways to Open a BFILE. This link takes you to section Reading a Portion of BFILE Data (substr). This link takes you to section Reading Data from a BFILE. This link takes you to section Comparing All or Parts of Two BFILES. This link takes you to section Checking If a Pattern Exists in the BFILE. This link takes you to section Displaying BFILE Data. This link takes you to section Two Ways to Close a BFILE. This link takes you to section Closing All Open BFILEs. This link takes you to the section Closing All Open BFILEs with FILECLOSEALL. This section takes you to the section, See if locators are equal. This link takes you to section Determining If a LOB Locator Is Initialized. This link takes you to section Loading a LOB with BFILE Data. This link takes you to section Loading Initial Data into External LOB (BFILE). This link takes you to section Getting the Length of a BFILE. This link takes you to section Checking If the BFILE Exists. This link takes you to section Two Ways to See If a BFILE is Open. This link takes you to section Get DIRECTORY Alias and Filename. This link takes you to section Copying a LOB Locator for a BFILE. This link takes you to section Determining If One LOB Locator for a BFILE Is Equal to Another. This link takes you to section Three Ways to Create a Table Containing One or More BFILE Columns. This link takes you to section Three Ways to Insert a Row Containing a BFILE. This link takes you to section Three Ways to Update a Row Containing a BFILE.
Text description of the illustration adl12bf3.gif

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback