Use Case Model: Internal Persistent LOBs Operations

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 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)

• CP -- C++, using OCCI (Oracle C++ 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

  LOB Use Case	Programmatic Environment Examples Provided Here
  	P	O	CP	B	C	V	J
  Appending One LOB to Another	+	+		+	+	+	+
  Java (JDBC): Appending One LOB to Another	+	+		+	+		+
  Character Set Form: Determining Character Set Form		+
  Character Set ID: Determining Character Set ID		+
  Checking In a LOB	+	+		+	+	+	+
  Checking Out a LOB	+	+		+	+	+	+
  Closing LOBs - see Chapter 3, "LOB Support in Different Programmatic Environments"
  Comparing All or Part of Two LOBs	+			+	+	+	+
  Copying a LOB Locator	+	+		+	+	+	+
  Copying All or Part of One LOB to Another LOB	+	+		+	+	+	+
  Creating Tables Containing LOBs
  Creating a Nested Table Containing a LOB	S	S		S	S	S	S
  Creating a Table Containing an Object Type with a LOB Attribute	S	S	S	S	S	S	S
  Creating a Table Containing One or More LOB Columns	S	S	S	S	S	S	S
  Creating a Varray Containing References to LOBs See Chapter 5, "Large Objects: Advanced Topics"	S	S	S	S	S	S	S
  Deleting the Row of a Table Containing a LOB	S	S	S	S	S	S	S
  Disabling LOB Buffering		+		+	+	+
  Displaying LOB Data	+	+		+	+	+	+
  Enabling LOB Buffering				+	+	+
  Equality: Checking If One LOB Locator Is Equal to Another		+			+		+
  Erasing Part of a LOB	+	+		+	+	+	+
  Flushing the Buffer		+		+	+
  Initialized Locator: Checking If a LOB Locator Is Initialized		+			+
  Inserting One or More LOB Values into a Row
  Inserting a LOB Value using EMPTY_CLOB() or EMPTY_BLOB()	S	S	S	S	S	S	+
  Inserting a Row by Initializing a LOB Locator Bind Variable	S	+		+	+	+	+
  Inserting a Row by Selecting a LOB From Another Table	S	S	S	S	S	S	S
  Length: Determining the Length of a LOB	+	+		+	+	+	+
  Loading a LOB with BFILE Data	+	+		+	+	+	+
  Loading Initial Data into a BLOB, CLOB, or NCLOB	+
  LONGs to LOBs	S	S	S	S	S	S	S
  LONG to LOB Copying, Using the TO_LOB Operator	S	S	S	S	S	S	S
  LONG to LOB Migration Using the LONG-to-LOB API	+	+
  Java (JDBC): Loading a LOB with Data from a BFILE	+	+		+	+		+
  Opening LOBs - see Chapter 3, "LOB Support in Different Programmatic Environments"
  Patterns: Checking for Patterns in the LOB (instr)	+			+	+		+
  Reading a Portion of the LOB (substr)	+			+	+	+	+
  Reading Data from a LOB	+	+		+	+	+	+
  Streaming LOB Data
  Trimming LOB Data	+	+		+	+	+	+
  Three Ways to Update a LOB or Entire LOB Data
  Updating a LOB with EMPTY_CLOB() or EMPTY_BLOB()	S	S	S	S	S	S	S
  Updating a Row by Selecting a LOB From Another Table	S	S	S	S	S	S	S
  Updating by Initializing a LOB Locator Bind Variable	S	+		+	+	+	+
  Write-Append, See Append-Write.
  Writing Data to a LOB	+	+	+	+	+	+	+

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

Text description of the illustration adl10p15.gif

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

Text description of the illustration adl10p25.gif