Use Case Model: Internal Persistent LOBs

Table 7-1, indicates with a + where examples are provided for specific use cases and in which programmatic environment. An "S" indicates that SQL is used directly for that use case and applicable programmatic environment(s).

We refer to programmatic environments by means of the following abbreviations:

• 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 9-1 Use Case Model: Internal Persistent LOBs Basic Operations

Use Case and Page	Programmatic Environment Examples
	P	O	B	C	V	J
Three Ways to Create a Table Containing a LOB
CREATE a Table Containing One or More LOB Columns	S	S	S	S	S	S
CREATE a Table Containing an Object Type with a LOB Attribute	S	S	S	S	S	S
CREATE a Nested Table Containing a LOB	S	S	S	S	S	S
(Creating a Varray Containing References to LOBs See Chapter 5, "Advanced Topics" )	S	S	S	S	S	S
Three Ways Of Inserting One or More LOB Values into a Row
INSERT a LOB Value using EMPTY_CLOB() or EMPTY_BLOB()	S	S	S	S	S	+
INSERT a Row by Selecting a LOB From Another Table	S	S	S	S	S	S
INSERT Row by Initializing a LOB Locator Bind Variable	S	+	+	+	+	+
Load Data into an Internal LOB (BLOB, CLOB, NCLOB)	+
Load a LOB with Data from a BFILE	+	+	+	+	+	+
See If a LOB Is Open	+	+	+	+		+
Copy LONG to LOB	S	S	S	S	S	S
Checkout a LOB	+	+	+	+	+	+
Checkin a LOB	+	+	+	+	+	+
Display LOB Data	+	+	+	+	+	+
Read Data from LOB	+	+	+	+	+	+
Read a Portion of the LOB (substr)	+		+	+	+	+
Compare All or Part of Two LOBs	+		+	+	+	+
See If a Pattern Exists in the LOB (instr)	+		+	+		+
Get the Length of a LOB	+	+	+	+	+	+
Copy All or Part of a LOB to Another LOB	+	+	+	+	+	+
Copy a LOB Locator	+	+	+	+	+	+
See If One LOB Locator Is Equal to Another		+		+		+
See If a LOB Locator Is Initialized		+		+
Get Character Set ID		+
Get Character Set Form		+
Append One LOB to Another	+	+	+	+	+	+
Write Append to a LOB	+	+	+	+		+
Write Data to a LOB	+	+	+	+	+	+
Trim LOB Data	+	+	+	+	+	+
Erase Part of a LOB	+	+	+	+	+	+
Enable LOB Buffering			+	+	+
Flush Buffer		+	+	+
Disable LOB Buffering		+	+	+	+
Three Ways to Update a LOB or Entire LOB Data
UPDATE a LOB with EMPTY_CLOB() or EMPTY_BLOB()	S	S	S	S	S	S
UPDATE a Row by Selecting a LOB From Another Table	S	S	S	S	S	S
UPDATE by Initializing a LOB Locator Bind Variable	S	+	+	+	+	+
DELETE the Row of a Table Containing a LOB	S	S	S	S	S	S

Figure 9-1 Use Case Model Diagram: Internal Persistent LOBs (part 1 of 2)

Figure 9-2 Use Case Model Diagram: Internal Persistent LOBs (part 2 of 2)