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), 10 of 41


Three Ways to Insert a Row Containing a BFILE

Figure 12-6 Use Case Diagram: Three Ways to Insert a Row Containing a BFILE


Text description of adl12b29.gif follows This link takes you back to the External LOBs (BFILES) main diagram. This link takes you to the diagram, Inserting a Row Using BFILENAME(). This link takes you to the diagram, Inserting a Row Containing a BFILE by Selecting a BFILE From Another Table (INSERT ... AS ... SELECT). This link takes you to the diagram, Inserting a Row by Initializing a BFILE Locator.
Text description of the illustration adl12b29.gif

See Also:

"Use Case Model: External LOBs (BFILEs)" for all basic operations of External LOBs (BFILES). 


Note:

Before you insert, you must initialize the BFILE either to NULL or to a directory alias and filename. 


The following are three ways to insert a row containing a BFILE:

    1. INSERT a Row Using BFILENAME()

    2. INSERT a BFILE Row by Selecting a BFILE From Another Table

    3. Inserting a Row With BFILE by Initializing a BFILE Locator


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