Oracle9i Application Developer's Guide - Large Objects (LOBs) -- Index

accessing external LOBs, 12-5

ALTER TABLE

migrating from LONG to LOB, 8-3

amount, 12-56

amount parameter

reading and loading LOB data, the size of (FAQ), 6-5

used with BFILEs, 12-38

ANSI standard for LOBs, 11-10

AppendChunk(), see OraOLEDB, 13-3

appending

one LOB to another

internal persistent LOBs, 10-82

one temporary LOB to another, 11-51

writing to the end of a LOB

internal persistent LOBs, 10-85

assigning

one collection to another collection in temporary LOBs, 11-11

one temporary LOB to another, 11-11

BFILENAME(), 12-24, 12-84

advantages of using, 12-7

BFILEs

accessing, 12-5

closing, 12-91

converting to CLOB or NCLOB, 12-38

creating an object in object cache, 5-18

datatype, 2-2, 2-3

equal locators, check for, 12-77

initializing using BFILENAME(), 2-7

locators, 2-6

maximum number of open, 4-2, 12-70

multi-threaded server (MTS), 12-11

Oracle Objects for OLE (OO4O)

opening/closing methods, 3-41

properties, 3-42

read-only methods, 3-42

reference semantics, 2-3

security, 12-8

storage devices, 2-2

binding data to internal LOBs, restriction removal, 4-17

binds

HEX to RAW or RAW to HEX conversion, 7-15

updating more than 4,000 bytes

internal persistent LOBs, 10-111

BLOBs

datatype, 2-2

buffering

disable

internal persistent LOBs, 10-106

enable

internal persistent LOBs, 10-100

flush

internal persistent LOBs, 10-103

LOB buffering subsystem, 5-22

C++, See Pro*C/C++ precompiler

C, See OCI

CACHE / NOCACHE, 7-8

caches

object cache, 5-18

callback, 10-47, 10-50, 10-57, 10-86, 11-56

catalog views

v$temporary_lobs, 11-12

CHAR buffer, defining on CLOB, 7-40

CHAR to CLOB

SQL and PL/SQL conversion, 7-35

character data

varying width, 2-4

character set form

getting

internal persistent LOBs, 10-80

character set ID

getting the

internal persistent LOBs, 10-78

temporary LOB of, getting the, 11-47

charactersets

multibyte,LONGs and LOBs, 8-5

checking in a LOB

internal persistent LOBs, 10-49

checking out a LOB

internal persistent LOBs, 10-46

CHUNK, 7-10

chunks

when to use, 6-28

chunksize, 10-89

multiple of, to improve performance, 10-58

classes

putChars(), 6-12

CLOBs

columns

varying- width character data, 2-4

datatype, 2-2

varying-width columns, 2-4

varying-width, 2-4

Clone method, See Oracle Objects for OLE (OO4O)

closing

all open BFILEs, 12-97

BFILEs, 12-91

BFILEs with CLOSE, 12-95

BFILEs with FILECLOSE, 12-93

clustered tables, 8-10

COBOL, See Pro*COBOL precompiler

code

example programs, 1-8

list of demonstration programs, 1-8

comparing

all or part of two LOBs

internal persistent LOBs, 10-63

all or part of two temporary LOBs, 11-33

all or parts of two BFILEs, 12-62

compatibility, 1-9

conventional path load, 9-3

conversion

explicit functions for PL/SQL, 7-48

conversions

character set, 12-38

character set conversions needed on BFILE before using LOADFROMFILE(), 11-21

from binary data to character set, 12-38

implicit, between CLOB and VARCHAR2, 7-46

See also binds HEX to RAW

conversions,implicit between CLOBs and CHAR, 7-36

converting

between different LOB types, 6-26

to CLOB, 7-48

converting to LOB data types, 6-4

copy semantics, 2-3

internal LOBs, 10-26

copying

all or part of a LOB to another LOB

internal persistent LOBs, 10-69

all or part of one temporary LOB to another, 11-39

for BFILEs there is no copy function, 12-86

LOB locator

internal persistent LOBs, 10-72

LOB locator for BFILE, 12-73

LONG to LOB, 10-37

LONG to LOB (FAQ), 6-4

temporary LOB locator, 11-41

TO_LOB limitations, 10-42

crashing

Is LOB data lost after (FAQ), 6-7

creating a temporary LOB, 11-14

creating tables

containing an object type with LOB attribute

internal Persistent LOBs, 10-13

containing BFILEs, 12-14

containing one or more LOB columns

internal persistent LOBs, 10-8

containing one ore more BFILE columns, 12-15

nested, containing LOB

internal persistent LOBs, 10-18

of an object type with BFILE attribute, 12-18

with a nested table containing a BFILE, 12-21

creating VARRAYs

containing references to LOBs, 5-29

datatypes

converting to LOBs FAQ, 6-4

DBMS_LOB

ERASE, 6-12

substr vs. read, 6-28

updating LOB with bind variable, 5-10

WRITE()

passing hexadecimal string to, 10-90

DBMS_LOB package

available LOB procedures/functions, 3-3, 3-4

.createTemporary() as JDBC workaround, 11-12

isTemporary() as JDBC workaround, 11-12

LOADFROMFILE(), 12-38

multi-threaded server (MTS), 12-11

WRITE()

guidelines, 10-90

guidelines for temporary LOBs, 11-56

passing hexadecimal string to, 11-56

DBMS_LOB()

READ, 10-57

DBMS_LOB.createtemporary(), 11-7

DBMS_LOB.READ, 12-56

DELETE

BLOB columns versus BFILE columns, and LOB indexing, 6-18

deleting

row containing LOB

internal persistent LOBs, 10-118

demonstration programs, 1-8

directories

catalog views, 12-10

guidelines for usage, 12-10

ownership and privileges, 12-8

DIRECTORY name specification, 12-8

DIRECTORY object, 12-5

catalog views, 12-10

getting the alias and filename, 12-79

guidelines for usage, 12-10

names on WindowsNT, 12-8

naming convention, 12-8

OS file must exist before locator use, and, 12-25

READ permission on object not individual files, 12-9

directory objects, 12-5

directory_alias parameter, 12-26

direct-path load, 9-3

disable buffering, See LOB buffering

DISABLE STORAGE IN ROW, 6-23

when to use, 6-21

disk striping of LOB files, B-3

displaying

LOB data for internal persistent LOBs, 10-53

temporary LOB data, 11-26

EMPTY_BLOB()

setdata using JPublisher (FAQ), 6-10

EMPTY_BLOB()/EMPTY_CLOB()

when to use (FAQ), 6-8

EMPTY_CLOB()

LOB locator storage, 6-22

EMPTY_CLOB()/BLOB()

to initialize a BFILE, 2-7

to initialize internal LOB

equal

one LOB locator to another

internal persistent LOBs, 10-74

one temporary LOB locator, to another, 11-43

equal locators

checking if one BFILE LOB locator equals another, 12-77

erasing

part of LOB

internal persistent LOBs, 10-97

part of temporary LOBs, 11-60

errors

ORA-03127, 6-13

examples

demonstration programs, 1-8

read consistent locators, 5-3

repercussions of mixing SQL DML with DBMS_LOB, 5-6

updated LOB locators, 5-8

updating a LOB with a PL/SQL variable, 5-10

existance

check for BFILE, 12-67

extensible indexes, 7-32

external callout, 5-24

external LOBs (BFILEs)

See BFILEs

external LOBs (BFILEs), See BFILEs

FILECLOSEALL(), 12-11, 12-41, 12-47

flushing

LOB buffer, 5-23

flushing buffer, 5-19

temporary LOB, 11-64

FOR UPDATE clause

LOB locator, 5-2

LOBs, 2-8

freeing

temporary LOBs, 11-18

FREETEMPORARY(), 11-18

freeTemporary() as JDBC workaround, 11-12

functional indexes, 7-32

function-based indexing, 1-8

GetChunk(), see OraOLEDB, 13-3

hexadecimal string

passing to DBMS_LOB.WRITE(), 10-90, 11-56

implicit conversions, 7-36

indexes

function-based, 1-8

rebuilding after LONG-to-LOB migration, 8-9

index-organized tables

inline storage for LOBs and (FAQ), 6-7

initialized

checking if BFILE LOB locator is, 12-75

initializing

BFILE column or locator variable using BFILENAME(), 12-25

BLOB attribute using EMPTY_BLOB() FAQ, 6-9

BLOB attribute with EMPTY_BLOB() in Java (FAQ), 6-9

during CREATE TABLE or INSERT, 10-24

external LOBs, 2-7

internal LOBs, See LOBs

internal LOBs

using EMPTY_CLOB(), EMPTY_BLOB()

inline

when to use, 6-29

INSERT statements

binds of greater than 4000 bytes, 7-14

inserting

a row by initializing a LOB locator

internal persistent LOBs, 10-28

a row by initializing BFILE locator, 12-30

a row by selecting a LOB from another table

internal persistent LOBs, 10-26

a row containing a BFILE, 12-23

a row containing a BFILE by selecting BFILE from another table, 12-28

a row using BFILENAME(), 12-24

any length data (FAQ), 6-4

binds of more than 4,000 bytes, 10-22

LOB value using EMPTY_CLOB()/EMPTY_BLOB()

internal persistent LOBs, 10-23

one or more LOB values into a row, 10-21

row with empty LOB using JDBS (FAQ), 6-9

interfaces for LOBs, see programmatic environments

Java, See JDBC

JDBC

available LOB methods/properties, 3-4

driver to load LOBs, improving performance, 6-15

inserting a row with empty LOB locator into table, 6-9

now binds and defines VARCHAR2 variables, 7-52

temporary LOB workarounds not needed, 11-12

JPublisher

building an empty LOB in, 6-10

LBS, See Lob Buffering Subsystem (LBS)

length

an internal persistent LOB, 10-67

getting BFILE, 12-70

temporary LOB, 11-37

LOADFROMFILE()

BFILE character set conversions needed before using, 11-21

loading

1Mb into CLOB column, FAQ, 6-15

a LOB with BFILE data, 12-37

data into internal LOB, 10-30

external LOB (BFILE) data into table, 12-33

LOB with data from a BFILE, 10-32

temporary LOB with data from BFILE, 11-20

loading XML documents, 9-2

LOB, 5-13

LOB buffering

buffer-enabled locators, 5-25

disable for temporaryLOBs, 11-66

example, 5-22

flushing for temporary LOBs, 11-64

flushing the buffer, 5-23

flushing the updated LOB through LBS, 5-24

guidelines, 5-19

OCI example, 5-26

OCILobFlushBuffer(), 5-24

Oracle Objects for OLE (OO4O)

methods for internal LOBs, 3-42

physical structure of buffer, 5-21

temporary LOBs

CACHE, NOCACHE, CACHE READS, 11-8

usage notes, 5-21

LOB Buffering SubSystem (LBS)

LOB Buffering Subsystem (LBS)

advantages, 5-19

buffer-enabled locators, 5-24

buffering example using OCI, 5-26

example, 5-22

flushing

updated LOB, 5-24

flushing the buffer, 5-23

guidelines, 5-19

saving the state of locator to avoid reselect, 5-25

usage, 5-21

LOB locator

copy semantics, 2-3

external LOBs (BFILEs), 2-3

internal LOBs, 2-3

reference semantics, 2-3

LOB-Based web site,building, 14-12

LOBFILE, syntax, 9-2

LOBs, 5-18

accessing through a locator, 2-8

attributes and object cache, 5-18

buffering

caveats, 5-19

pages can be aged out, 5-24

buffering subsystem, 5-19

buffering usage notes, 5-21

CACHE READS setting, 4-17

compatibility, 1-9

datatypes versus LONG, 1-4

external (BFILEs), 2-2

flushing, 5-19

in partitioned tables, 7-26

in the object cache, 5-18

index metadata through system views, 6-19

inline storage, 2-6

interfaces, See programmatic environments

interMEDIA, 1-4

internal

creating an object in object cache, 5-18

internal LOBs

CACHE / NOCACHE, 7-8

CHUNK, 7-10

copy semantics, 2-3

ENABLE | DISABLE STORAGE IN ROW, 7-11

initializing, 12-55

locators, 2-6

locking before updating, 10-70, 10-83, 10-86, 10-89, 10-94, 10-98

LOGGING / NOLOGGING, 7-9

Oracle Objects for OLE (OO4O), modifying methods, 3-40

PCTVERSION, 7-7

setting to empty, 2-10

tablespace and LOB index, 7-7

tablespace and storage characteristics, 7-5

transactions, 2-2

locators, 2-6, 5-2

cannot span transactions, 7-14

migration issues, 1-9

object cache, 5-18

performing SELECT on, 2-8

piecewise operations, 5-6

read consistent locators, 5-2

reason for using, 1-2

setting to contain a locator, 2-6

setting to NULL, 2-9

tables

adding partitions, 7-31

creating, 7-28

creating indexes, 7-30

exchanging partitions, 7-31

merging partitions, 7-32

moving partitions, 7-31

partitioning, 7-28

splitting partitions, 7-31

typical uses, B-2

unstructured data, 1-2

updated LOB locators, 5-6

value, 2-6

varying-width character data, 7-3

locators, 2-6

accessing a LOB through, 2-8

BFILEs, 12-12

guidelines, 12-12

two rows can refer to the same file, 12-12

buffer-enabled, 5-25

cannot span transactions, 7-14

copying temporary LOB, 11-41

external LOBs (BFILEs), 2-6

initializing LOB or BFILE to contain, 2-7

LOB, cannot span transactions, 5-13

multiple, 5-3

read consistent, 5-2, 5-3, 5-11, 5-13, 5-24, 5-26, 5-27, 5-28

read consistent locators, 5-2

read consistent locators provide same LOB value regardless when SELECT occurs, 5-3

read consistent,updating, 5-2

reading and writing to a LOB using, 5-15

saving the state to avoid reselect, 5-25

see if LOB locator is initialized

internal persistent LOBs, 10-76

selecting, 2-8

selecting within a transaction, 5-17

selecting without current transacation, 5-16

setting column or attribute to contain, 2-6

temporary, SELECT permanent LOB INTO, 11-9

transaction boundaries, 5-15

updated, 5-6, 5-10, 5-23

updating, 5-13

LOGGING

migrating LONG-to-LOBs, 8-10

LOGGING / NOLOGGING, 7-9

LONG API

See LONG-to-LOB, 8-2

LONG versus LOB datatypes, 1-4

LONG-to-LOB Migration, 8-2

LONG-to-LOB migration

ALTER TABLE, 8-6

changes needed, 8-23

clustered tables, 8-10

examples, 8-25

LOGGING, 8-10

Multibyte Charactersets, 8-5

NULLs, 8-12

OCI, 8-3, 8-13

parameter passing, 8-6

performance, 8-43

PL/SQL, 8-5

rebuilding indexes, 8-9

replication, 8-10

space requirements, 8-10

triggers, 8-11

utldtree.sql use for PL/SQL, 8-24

lONG-to-LOB migration

PL/SQL, 8-17

migrating

LONG to LOBs, 6-25

LONG to LOBs, see LONG-to-LOB, 8-2

LONG-to-LOB using ALTER TABLE, 8-6

LONG-to-LOBs, constraints maintained, 8-8

LONG-to-LOBs, indexing, 8-9

migration, 1-9

multi-threaded server (MTS)

BFILEs, 12-11

national language support

NCLOBs, 2-2

NCLOBs

datatype, 2-2

varying-width, 2-4

NOCOPY restrictions, 11-12

NOCOPY, using to pass temporary LOB parameters by reference, 9-7

non-NULL

before writing to LOB column make it

internal persistent LOBs, 10-111

IS, 7-43

VARCHAR2

and CLOBs, IS, 7-43

NULL, 7-43

null

versus zero length, in SQL92 standard, 7-44

NULL in, 7-43

object cache, 5-18

creating an object in, 5-18

LOBs, 5-18

OCCI

compared to other interfaces, 3-3

OCI

available LOB functions, 3-3

LOB buffering example, 5-26

locators, 2-8

now binds and defines VARCHAR2 variables with LOBs, 7-52

temporary lobs can be grouped into logical buckets, 11-8

using in LONG-to-LOB migration, 8-13

using to work LOBs, 3-10

OCIBindByName(), 7-14

OCIBindByPos(), 7-14

OCIDuration(), 11-8

OCIDurationEnd(), 11-8, 11-18

OCILobAssign(), 5-21, 11-10

OCILobFileSetName(), 12-7, 12-12

OCILobFlushBuffer(), 5-24

OCILOBFreeTemporary(), 11-18

OCILobGetLength(), 12-56

OCILobLoadFromFile(), 12-38

OCILobRead

BFILEs, 12-56

OCILobRead(), 10-54, 10-57, 11-29, 12-56

amount, 6-7

to read large amounts of LOB data, 10-47

OCILobWrite(), 11-56

to write large amounts of LOB data, 10-50

OCILobWriteAppend(), 10-86

OCIObjectFlush(), 12-12

OCIObjectNew(), 12-12

OCISetAttr(), 12-13

OLEDB, 3-15, 13-2

OO4O, See Oracle Objects for OLE (OO4O)

open

checking for open BFILEs, 12-46

checking for open BFILEs with FILEISOPEN(), 12-48

checking if BFILE is open with ISOPEN, 12-50

checking if temporary LOB is, 11-24

seeing if a LOB is open, 10-35

opening

BFILEs, 12-40

BFILEs using FILEOPEN, 12-42

BFILEs with OPEN, 12-44

OraBfile, See Oracle Objects for OLE (OO4O)

OraBlob, See Oracle Objects for OLE (OO4O)

Oracle Call Interface, See OCI

Oracle Objects for OLE (OO4O)

available LOB methods/properties, 3-4

internal LOB buffering, 3-37

modifying internal LOBs, 3-51

opening/closing external LOBs (BFILEs), 3-54

OraBfile example

OraBlob example

OraBlob, OraClob, and OraBfile encapsulate locators, 3-37

properties for operating on external LOBs (BFILEs), 3-42

properties for operating on LOBs, 3-42

reading/examining internal LOB and external LOB (BFile) values, 3-41

read-only methods for external LOBs (BFILEs), 3-42

syntax reference, 3-36

using Clone method to retain locator independent of dynaset, 3-37

Oracle Provider for OLEDB, see OraOLEDB, 13-2

ORaOLEDB

AppendChunk(), 13-3

OraOLEDB, 3-15, 13-1, 13-2

GetChunk(), 13-3

partitioned index-organized tables

for LOBs, 5-30

restrictions for LOBs, 5-31

pattern

check if it exists in BFILE using instr, 12-65

see if it exists IN LOB using (instr)

internal persistent LOBs, 10-65

temporary LOBs

checking if it exists, 11-35

PCTVERSION, 7-7

performance

assigning multiple locators to same temporary LOB, impacts, 11-10

chunks versus reading, 6-28

creating temporary LOBs in called routine (FAQ), 6-30

guidelines (FAQ), 6-28

improving BLOB and CLOB, when loading with JDBC driver, 6-15

improving loading, when using Veritas, 6-26

inlining and when its a good idea to use (FAQ), 6-29

LONG-to-LOB migration, 8-43

when using SQL semantics with LOBs, 7-44

PIOTssee partitioned index-organized tables

PL/SQ

inserting Word document into a BLOB, 14-5

PL/SQL, 3-2

and LOBs, semantics changes, 7-45

changing locator-data linkage, 7-49

CLOB variables in, 7-49

CLOB variables in PL/SQL, 7-49

CLOB versus VARCHAR2 comparison, 7-51

CLOBs passed in like VARCHAR2s, 7-48

defining a CLOB Variable on a VARCHAR, 7-47

freeing temporary LOBs automatically and manually, 7-50

OCI and Java LOB interactions, 7-52

using in LONG-to-LOB migration, 8-17

polling, 10-47, 10-50, 10-57, 10-86, 11-56

populating your data repository, 14-4

Pro*C/C++ precompiler

available LOB functions, 3-3

Pro*COBOL precompiler

available LOB functions, 3-3

programmatic environments, 3-2

available functions, 3-3

compared, 3-3

putChars(), 6-12

read consistency

LOBs, 5-2

read consistent locators, 5-2, 5-3, 5-11, 5-13, 5-24, 5-26, 5-27, 5-28

reading

BFILES

specify 4 Gb-1 regardless of LOB, 12-56

data fom temporary LOB, 11-28

data from a LOB

internal persistent LOBs, 10-56

large amounts of LOB data using streaming, 10-47

portion of BFILE data using substr, 12-59

portion of LOB using substr

internal persistent LOBs, 10-60

portion of temporary LOB, 11-31

small amounts of data,enable buffering, 10-101

Recordsets, ADO, 13-3

redo space

during LONG-to-LOB migration, prevent generation, 9-10

reference semantics, 2-3, 10-26

BFILEs enables multiple BFILE columns per record, 12-7

replication, 8-10

restrictions

binding of data, removed for INSERTS and UPDATES, 4-17

binds of more than 4000 bytes, 7-16

partitioned index-organized tables and LOBs, 5-31

retrieving data, 14-9

roundtrips to the server, avoiding, 5-19, 5-26

Rowset, OLEDB, 13-2

sample programs, 1-8

searching for data, 14-6

security

BFILEs, 12-8

BFILEs using SQL DDL, 12-9

BFILEs using SQL DML, 12-10

segment

LOB restriction, must be a tleast 3 blocks, 4-16

SEGMENT SPACE MANAGEMENT

Auto, LOBs cannot be stored with, 4-16

SELECT statement

FOR UPDATE, 2-8

read consistency, 5-2

selecting a permanent LOB INTO a temporary LOB locator, 11-9

semantics

copy-based for internal LOBs, 10-26

pseudo-reference, 11-10

reference based for BFILEs, 12-7

value, 11-10

SESSION_MAX_OPEN_FILES parameter, 4-2, 12-41, 12-46

setData

setting to EMPTY_BLOB() using JPublisher, 6-10

setting

internal LOBs to empty, 2-10

LOBs to NULL, 2-9

space requirements,LONG-to-LOB migration, 8-10

spatial cartridge and user-defined aggregates, 7-54

SQL

features where LOBs cannot be used, 7-40

functions and operators,returning CLOB values from, 7-41

RAW type and BLOBs, 7-44

where LOBs cannot be used, 7-40

SQL DDL

BFILE security, 12-9

SQL DML

BFILE security, 12-10

SQL Loader

loading InLine LOB data, 4-7

performance for internal LOBs, 4-6

SQL semantics on LOBs

non-supported functionality, 7-35

SQL*Loader

conventional path load, 9-3

direct-path load, 9-3

LOBFILE, 9-2

storing

CLOBs Inline, 6-23

greater than 4GB LOBs in database (FAQ), 6-29

LOB storage clause,when to use with varrays, 6-23

storing images in a BFILE versus BLOB, 6-20

stream

reading

temporary LOBs, 11-29

writing, 11-56

streaming, 10-50, 10-54

do not enable buffering, when using, 10-101

write, 10-89

system owned object, See DIRECTORY object

tablespace

LOB index in same, FAQ, 6-18

specified with ENABLE STORAGE IN ROW, FAQ, 6-19

temporary, 11-8

temporary LOB data stored in temporary, 11-7

temporary LOBs

character set ID, 11-47

checking if LOB is temporary, 11-16

data stored in temporary tablespace, 11-7

disable buffering

explcitly freeing before overwriting it with permanent LOB locator, 11-9

features, 11-10

inline and out-of-line not used, 11-7

JDBC, 11-12

lifetime and duration, 11-8

locators can be IN values, 11-6

locators operate as with permanent LOBs, 11-6

memory handling, 11-8

OCI and logical buckets, 11-8

performance, 11-10

reside on server not client, 11-8

similar functions used to permanent LOBs, 11-7

SQL DML does not operate on, 11-6

transactions and consistent reads not suuported, 11-7

trimming, 11-58

write append to, 11-53

temporary tablespace

for binds of more than 4000 bytes, 7-14

TO_BLOB(),TO_CHAR(), TO_NCHAR(), 7-48

TO_CLOB()

converting VARCHAR2,NVARCHAR2,NCLOB to CLOB, 7-48

TO_LOB

limitations, 10-42

TO_NCLOB(), 7-48

transaction boundaries

LOB locators, 5-15

transaction IDs, 5-15

transactions

external LOBs do not participate in, 2-3

IDs of locators, 5-15

internal LOBs participate fully, 2-2

LOB locators cannot span, 5-13

LOBs locators cannot span, 7-14

locators with non-serializable, 5-16

locators with serializable, 5-16

migrating from, 5-24

triggers

LOB columns with, how to tell when updated (FAQ), 6-5

LONG-to-LOB migration, 8-11

trimming

LOB data

internal persistent LOBs, 10-93

temporary LOB data, 11-58

Trusted Oracle and user-defined aggregates, 7-54

UDAGs, see user-defined aggregates

UNICODE

VARCHAR2 and CLOBs support, 7-39

Unified Modeling Language (UML), A-1

unstructured data, 1-2

UPDATE statements

binds of greater than 4000 bytes, 7-14

updated locators, 5-6, 5-10, 5-23

updating

a row containing a BFILE, 12-82

any length data (FAQ), 6-4

avoid the LOB with different locators, 5-8

BFILEs by selecting a BFILE from another table, 12-86

BFILEs using BFILENAME(), 12-83

by initializinga LOB locator bind variable

internal persistent LOBs, 10-115

by selecting a LOB from another table

internal persistent LOBs, 10-113

LOB values using one locator, 5-8

LOB values, read consistent locators, 5-2

LOB with PL/SQL bind variable, 5-10

LOBs using SQL and DBMS_LOB, 5-6

locking before, 10-70

locking prior to, 10-83, 10-94, 10-98

with EMPTY_CLOB()/EMPTY_BLOB()

internal persistent LOBs, 10-110

upding

locators, 5-13

UPLOAD_AS_BLOB and DAD, 6-32

use case diagrams, A-1

use cases

full list of internal persistent LOBs, 10-2

model, graphic summary of, 10-1

user-defined aggregates (UDAGs) and LOBs, 7-54

utldtree.sql, 8-24

value of LOBs, 2-6

VARCHAR2

accessing CLOB data when treated as, 7-47

also RAW,applied to CLOBs and BLOBs, 7-40

defining CLOB variable on, 7-47

OCI and JDBC now bind and define variables to SQL, PL/SQL with LOBs, 7-52

VARCHAR2s

on CLOBs,SQL functions and operators for, 7-35

VARRAYs

See creating VARRAYs

varrays

including LOB storage clause to create tables (FAQ), 6-23

varying-width character data, 2-4

Veritas with LOBs, 6-26

views on DIRECTORY object, 12-10

Visual Basic, See Oracle Objects for OLE(OO4O)

web-sites, building LOB-based, 14-12

write

streaming, 11-56

write appending

to temporary LOBs, 11-53

writing

data to a LOB

internal persistent LOBs, 10-88

data to a temporary LOB, 11-55

singly or piecewise, 10-86

small amounts of data, enable buffering, 10-101

XML, loading, 9-2