Use Case Model: External LOBs (BFILEs)

Table 11-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 Programmatic Environments" for a complete discussion and references to related manuals).

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

• P -- PL/SQL using the DBMS_LOB Package

• O -- C using OCI (Oracle Call Interface)

• B -- COBOL using Pro*COBOL precompiler

• C -- C/C++ using Pro*C/C++ precompiler

• V -- Visual Basic using OO4O (Oracle Objects for OLE)

• J -- Java using JDBC (Java Database Connectivity)

• S -- SQL

Table 11-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
CREATE a Table Containing One or More BFILE Columns	S	S	S	S	S	S
CREATE a Table of an Object Type with a BFILE Attribute	S	S	S	S	S	S
CREATE 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
INSERT Row With BFILE by Initializing BFILE Locator	+	+	+	+	+	+
Load Data Into External LOB (BFILE)	S	S	S	S	S	S
Load a LOB with BFILE Data	+	+	+	+	+	+
Two Ways to Open a BFILE
Open a BFILE with FILEOPEN	+	+				+
Open a BFILE with OPEN	+	+	+	+	+	+
Two Ways to See If a BFILE is Open
See If the BFILE is Open with FILEISOPEN	+	+				+
See If a BFILE is Open Using ISOPEN	+	+	+	+	+	+
Display BFILE Data n	+	+	+	+	+	+
Read Data from a BFILE n	+	+	+	+	+	+
Read a Portion of BFILE Data (substr)	+		+	+	+	+
Compare All or Parts of Two BFILES	+		+	+	+	+
See If a Pattern Exists (instr) in the BFILE	+		+	+		+
See If the BFILE Exists	+	+	+	+	+	+
Get the Length of a BFILE	+	+	+	+	+	+
Copy a LOB Locator for a BFILE	+	+	+	+		+
See If a LOB Locator for a BFILE Is Initialized		+		+
See If One LOB Locator for a BFILE Is Equal to Another		+		+		+
Get DIRECTORY Alias and Filename n	+	+	+	+	+	+
Three Ways to Update a Row Containing a BFILE
UPDATE a BFILE Using BFILENAME()	S	S	S	S	S	S
UPDATE a BFILE by Selecting a BFILE From Another Table	S	S	S	S	S	S
UPDATE a BFILE by Initializing a BFILE Locator	+	+	+	+	+	+
Two Ways to Close a BFILE
Close a BFILE with FILECLOSE n	+	+			+	+
Close a BFILE with CLOSE	+	+	+	+	+	+
Close All Open BFILEs	+	+	+	+	+	+
DELETE the Row of a Table Containing a BFILE	S	S	S	S	S	S

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