Index

A  B  C  D  E  F  H  I  J  L  M  N  O  P  R  S  T  U  V  W 

---

A

accessing external LOBs, 11-5

amount parameter

reading and loading LOB data, the size of, 6-4

used with BFILEs, 11-47

ANSI standard for LOBs, 10-10

appending

one LOB to another

internal persistent LOBs, 9-182

one temporary LOB to another, 10-133

write appending to a LOB

internal persistent LOBs, 9-192

assigning

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

one temporary LOB to another, 10-10

---

B

BFILE class, See JDBC

BFILE-buffering, See JDBC

BFILENAME(), 11-24, 11-183

advantages of using, 11-7

BFILEs

accessing, 11-5

closing, 11-196

converting to CLOB or NCLOB, 11-47

creating an object in object cache, 5-20

datatype, 2-2, 2-3

DBMS_LOB read-only procedures, 3-9

DBMS_LOB,offset and amount parameters in bytes, 3-7

equal locators, check for, 11-165

initializing using BFILENAME(), 2-6

locators, 2-5

maximum number of open, 4-2, 11-143

multi-threaded server (MTS), 11-12

OCI functions to read/examine values, 3-15

OCI read-only functions, 3-15

Oracle Objects for OLE (OO4O)

opening/closing methods, 3-34

properties, 3-36

read-only methods, 3-36

Pro*C/C++ precompiler statements, 3-24

Pro*COBOL precompiler embedded SQL statements, 3-28

reading with DBMS_LOB, 3-8

read-only support, 4-16

reference semantics, 2-3

security, 11-8, 11-9

storage devices, 2-2

using JDBC to read/examine, 3-42

using Pro*C/C++ precompiler to open and close, 3-25

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

binds

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

updating more than 4,000 bytes

internal persistent LOBs, 9-258

See also INSERT statements and UPDATE statements

BLOB-buffering,See JDBC

BLOBs

class, See JDBC

datatype, 2-2

DBMS_LOB, offset and amount parameters in bytes, 3-7

modify via DBMS_LOB, 3-8

using JDBC to modify, 3-39

using JDBC to read/examine BLOB values, 3-39

using oracle.sql.BLOB methods to modify, 3-39

buffering

disable

internal persistent LOBs, 9-250

enable

internal persistent LOBs, 9-238

flush

internal persistent LOBs, 9-244

---

C

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

C, See OCI

CACHE / NOCACHE, 7-8

caches

object cache, 5-20

callback, 9-65, 9-76, 9-103, 9-193, 10-152

catalog views

v$temporary_lobs, 10-13

character data

varying width, 2-4

character set form

getting

internal persistent LOBs, 9-178

character set ID

getting the

internal persistent LOBs, 9-174

temporary LOB of, getting the, 10-127

See CSID parameter

checking in a LOB

internal persistent LOBs, 9-75

checking out a LOB

internal persistent LOBs, 9-64

CHUNK, 7-10

chunksize, 9-202

multiple of, to improve performance, 9-103

CLOB class, See JDBC

CLOB-buffering, See JDBC

CLOBs

columns

varying- width character data, 2-4

datatype, 2-2

varying-width columns, 2-4

DBMS_LOB, offset and amount parameters in characters, 3-7

modify via DBMS_LOB, 3-8

reading/examining with JDBC, 3-41

using JDBC to modify, 3-40

varying-width, 2-4

Clone method, See Oracle Objects for OLE (OO4O)

closing

all open BFILEs, 11-211

BFILEs, 11-196

BFILEs with CLOSE, 11-203

BFILEs with FILECLOSE, 11-198

COBOL, See Pro*COBOL precompiler

code

example programs, 1-5

list of demonstration programs, 1-5

comparing

all or part of two LOBs

internal persistent LOBs, 9-120

all or part of two temporary LOBs, 10-75

all or parts of two BFILEs, 11-116

compatibility, 1-5

conversions

character set, 11-47

character set conversions needed on BFILE before using LOADFROMFILE(), 10-34

from binary data to character set, 11-47

See also binds HEX to RAW

converting to LOB data types, 6-3

copy semantics, 2-3

internal LOBs, 9-27

copying

all or part of a LOB to another LOB

internal persistent LOBs, 9-143

all or part of one temporary LOB to another, 10-98

for BFILEs there is no copy function, 11-185

LOB locator

internal persistent LOBs, 9-154

LOB locator for BFILE, 11-152

LONG to LOB, 6-3, 9-59

temporary LOB locator, 10-108

TO_LOB limitations, 9-60

creating a temporary LOB, 10-14

creating tables

containing an object type with LOB attribute

internal Persistent LOBs, 9-13

containing BFILEs, 11-14

containing one or more LOB columns

internal persistent LOBs, 9-8

containing one ore more BFILE columns, 11-15

nested, containing LOB

internal persistent LOBs, 9-18

of an object type with BFILE attribute, 11-18

with a nested table containing a BFILE, 11-21

creating VARRAYs

containing references to LOBs, 5-32

CSID parameter

setting OCILobRead and OCILobWrite to OCI_UCS2ID, 3-11

---

D

datatypes

converting to LOBs FAQ, 6-3

DBMS_LOB

WRITE()

passing hexadecimal string to, 9-203

DBMS_LOB package

available LOB procedures/functions, 3-3

client procedures cannot call DBMS_LOB, 3-6

CREATETEMPORARY(), 10-16

for temporary LOBs, 3-8

functions/procedures to modify BLOB, CLOB, and NCLOB, 3-8

functions/procedures to read/examine internal and external LOBs, 3-8

LOADFROMFILE(), 11-47

multi-threaded server (MTS), 11-12

offset and amount parameter rules, 3-7

opening/closing internal and external LOBs, 3-9

provide LOB locator before invoking, 3-6

read-only functions/procedures for BFILEs, 3-9

to work with LOBs, using, 3-6

WRITE()

guidelines, 9-203

guidelines for temporary LOBs, 10-152

passing hexadecimal string to, 10-152

DBMS_LOB()

READ, 9-102

deleting

row containing LOB

internal persistent LOBs, 9-273

demonstration programs, 1-5

directories

catalog views, 11-10

guidelines for usage, 11-11

ownership and privileges, 11-9

DIRECTORY name specification, 11-8

DIRECTORY object, 11-5

catalog views, 11-10

getting the alias and filename, 11-172

guidelines for usage, 11-11

names on WindowsNT, 11-8

naming convention, 11-8

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

READ permission on object not individual files, 11-9

directory objects, 11-5

directory_alias parameter, 11-26

disable buffering, See LOB buffering

disk striping of LOB files, 8-3

displaying

LOB data for internal persistent LOBs, 9-90

temporary LOB data, 10-47

downgrading to 8.0 or 8.1.5, using CACHE READS LOBs, 4-16

---

E

embedded SQL statements, See Pro*C/C++ precompiler and Pro*COBOL precompiler

EMPTY_BLOB()/EMPTY_CLOB()

when to use FAQ, 6-7

EMPTY_CLOB()/BLOB()

to initialize a BFILE, 2-6

to initialize internal LOB

equal

one LOB locator to another

internal persistent LOBs, 9-162

one temporary LOB locator, to another, 10-118

equal locators

checking if one BFILE LOB locator equals another, 11-165

erasing

part of LOB

internal persistent LOBs, 9-228

part of temporary LOBs, 10-171

examples

demonstration programs, 1-5

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, 11-134

external callout, 5-26

external LOBs (BFILEs)

See BFILEs

external LOBs (BFILEs), See BFILEs

---

F

FILECLOSEALL(), 11-11, 11-56, 11-71

flushing buffer, 5-21

temporary LOB, 10-187

FOR UPDATE clause

LOBs, 2-7

LOBs locator, 5-2

freeing

temporary LOBs, 10-28

FREETEMPORARY(), 10-28

---

H

hexadecimal string

passing to DBMS_LOB.WRITE(), 9-203, 10-152

---

I

index-organized tables

inline storage for LOBs and, 6-6

initialized

checking if BFILE LOB locator is, 11-160

initializing

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

BLOB attribute using EMPTY_BLOB() FAQ, 6-8

during CREATE TABLE or INSERT, 9-24

external LOBs, 2-6

internal LOBs, See LOBs

internal LOBs

using EMPTY_CLOB(), EMPTY_BLOB()

INSERT statements

binds of greater than 4000 bytes, 7-16

inserting

a row by initializing a LOB locator

internal persistent LOBs, 9-29

a row by initializing BFILE locator, 11-34

a row by selecting a LOB from another table

internal persistent LOBs, 9-27

a row containing a BFILE, 11-23

a row containing a BFILE by selecting BFILE from another table, 11-32

a row using BFILENAME(), 11-24

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

LOB value using EMPTY_CLOB()/EMPTY_BLOB()

internal persistent LOBs, 9-23

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

interfaces for LOBs, see programmatic environments

---

J

Java, See JDBC

JDBC

available LOB methods/properties, 3-3

BFILE class

BFILE-buffering, 3-43

BLOB and CLOB classes

calling DBMS_LOB package, 3-37

changing internal LOBs with Java using objects oracle.sql.BLOB/CLOB, 3-37

encapsulating locators

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

methods/properties for BLOB-buffering, 3-40

methods/properties for CLOB-buffering, 3-41

modifying BLOB values, 3-39

modifying CLOB values, 3-40

OracleBlob, OracleClob do not work in 8.1.x, 3-43

reading internal LOBs and external LOBs (BFILEs) with Java, 3-37

reading/examining BLOB values, 3-39

reading/examining CLOB values, 3-41

reading/examining external LOB (BFILE) values, 3-42

referencing LOBs, 3-37

syntax references, 3-38

using OracleResultSet to reference LOBs, 3-38

using OUT parameter from OraclePreparedStatement to reference LOBs, 3-38

JPublisher

building an empty LOB in, 6-9

---

L

LBSLOB Buffering Subsystem (LBS)

length

an internal persistent LOB, 9-135

getting BFILE, 11-143

temporary LOB, 10-89

LOADFROMFILE()

BFILE character set conversions needed before using, 10-34

loading

a LOB with BFILE data, 11-46

data into internal LOB, 9-38

external LOB (BFILE) data into table, 11-42

LOB with data from a BFILE, 9-40

temporary LOB with data from BFILE, 10-33

LOB, 5-13

LOB buffering

BLOB-buffering with JDBC, 3-40

buffer-enabled locators, 5-27

disable for temporaryLOBs, 10-194

example, 5-24

flushing for temporary LOBs, 10-187

flushing the buffer, 5-25

flushing the updated LOB through LBS, 5-26

guidelines, 5-21

OCI example, 5-28

OCI functions, 3-16

OCILobFlushBuffer(), 5-26

Oracle Objects for OLE (OO4O)

methods for internal LOBs, 3-35

physical structure of buffer, 5-23

Pro*C/C++ precompiler statements, 3-25

Pro*COBOL precompiler statements, 3-29

temporary LOBs

CACHE, NOCACHE, CACHE READS, 10-8

usage notes, 5-23

LOB Buffering SubSystem (LBS)

LOB Buffering Subsystem (LBS)

advantages, 5-21

buffer-enabled locators, 5-26

buffering example using OCI, 5-28

example, 5-24

flushing the buffer, 5-25

flushing the updated LOB, 5-26

guidelines, 5-21

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

usage, 5-23

LOB locator

copy semantics, 2-3

external LOBs (BFILEs), 2-3

internal LOBs, 2-3

reference semantics, 2-3

LOBs, 5-20

accessing through a locator, 2-7

attributes and object cache, 5-20

buffering

caveats, 5-21

pages can be aged out, 5-26

buffering subsystem, 5-21

buffering usage notes, 5-23

compatibility, 1-5

datatypes versus LONG, 1-3

external (BFILEs), 2-2

flushing, 5-21

in partitioned tables, 7-26

in the object cache, 5-20

inline storage, 2-5

interfaces, See programmatic environments

interMEDIA, 1-4

internal

creating an object in object cache, 5-20

internal LOBs

CACHE / NOCACHE, 7-8

CHUNK, 7-10

copy semantics, 2-3

ENABLE | DISABLE STORAGE IN ROW, 7-11

initializing, 11-98

locators, 2-5

locking before updating, 9-144, 9-183, 9-193, 9-202, 9-219, 9-229

LOGGING / NOLOGGING, 7-9

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

PCTVERSION, 7-7

setting to empty, 2-9

tablespace and LOB index, 7-7

tablespace and storage characteristics, 7-5

transactions, 2-2

locators, 2-5, 5-2

cannot span transactions, 7-15

migration issues, 1-5

object cache, 5-20

performance, best practices, 7-34

performing SELECT on, 2-7

piecewise operations, 5-6

read consistent locators, 5-2

reason for using, 1-2

setting to contain a locator, 2-5

setting to NULL, 2-8

tables

adding partitions, 7-31

creating, 7-28

creating indexes, 7-30

exchanging partitions, 7-30

merging partitions, 7-31

moving partitions, 7-31

partitioning, 7-28

splitting partitions, 7-31

typical uses, 8-2

unstructured data, 1-2

updated LOB locators, 5-5

value, 2-5

varying-width character data, 7-3

locators, 2-5

accessing a LOB through, 2-7

BFILEs, 11-12

guidelines, 11-12

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

buffer-enabled, 5-27

cannot span transactions, 7-15

copying temporary LOB, 10-108

external LOBs (BFILEs), 2-5

initializing LOB or BFILE to contain, 2-6

LOB, cannot span transactions, 5-13

multiple, 5-2

OCI functions, 3-16

Pro*COBOL precompiler statements, 3-29

providing in Pro*COBOL precompiler, 3-26

read consistent, 5-2, 5-3, 5-10, 5-13, 5-25, 5-28, 5-29, 5-30

read consistent locators, 5-2

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

reading and writing to a LOB using, 5-16

saving the state to avoid reselect, 5-27

see if LOB locator is initialized

internal persistent LOBs, 9-169

selecting, 2-7

setting column or attribute to contain, 2-5

temporary, SELECT permanent LOB INTO, 10-9

transaction boundaries, 5-16

updated, 5-2, 5-5, 5-10, 5-13, 5-25

LOGGING / NOLOGGING, 7-9

LONG versus LOB datatypes, 1-3

---

M

migration, 1-5

multimedia

content-collection, 8-2

Multimedia_tab, 9-1

table structure, 8-5

multi-threaded server (MTS)

BFILEs, 11-12

---

N

national language support

NCLOBs, 2-2

NCLOBs

datatype, 2-2

DBMS_LOB, offset and amount parameters in characters, 3-7

modify via DBMS_LOB, 3-8

varying-width, 2-4

NOCOPY restrictions, 10-12

non-NULL

before writing to LOB column make it

internal persistent LOBs, 9-261

---

O

object cache, 5-20

creating an object in, 5-20

LOBs, 5-20

object-relational design, 8-4

OCI

available LOB functions, 3-3

buffering example, 5-28

functions for BFILEs, 3-15

functions for temporary LOBs, 3-15

functions to modify internal LOB values, 3-14

functions to open/close internal and external LOBs, 3-16

functions to read or examine internal and external LOB values, 3-15

LOB locator functions, 3-16

Lob-buffering functions, 3-16

locators, 2-7

NCLOB parameters, 3-13

OCILobFileGetLength

CLOB and NCLOB input and output length, 3-12

OCILobRead

varying-width CLOB and NCLOB input and amount amounts, 3-12

OCILobWrite

varying-width CLOB and NCLOB input and amount amounts, 3-12

offset and amount parameter rules

fixed-width character sets, 3-11

seeIfLOBOpen and how to use main(), 3-17

setting OCILobRead, OCILobWrite to OCI_UCS2ID, 3-11

temporary LOBs, 10-12

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

using to work LOBs, 3-11

OCIBindByName(), 7-16

OCIBindByPos(), 7-16

OCIDuration(), 10-8

OCIDurationEnd(), 10-8, 10-12, 10-28

OCILobAssign(), 5-22, 10-10

OCILobFileSetName(), 11-7, 11-13

OCILobFlushBuffer(), 5-26

OCILOBFreeTemporary(), 10-28

OCILobGetLength(), 11-99

OCILobLoadFromFile(), 11-48

OCILobRead(), 9-91, 9-102, 10-58, 11-99

amount, 6-6

to read large amounts of LOB data, 9-65

OCILobWrite(), 10-152

to write large amounts of LOB data, 9-76

OCILobWriteAppend(), 9-193

OCIObjectFlush(), 11-13

OCIObjectNew(), 11-13

OCISetAttr(), 11-13

OO4O, See Oracle Objects for OLE (OO4O)

open

checking for open BFILEs, 11-70

checking for open BFILEs with FILEISOPEN(), 11-72

checking if BFILE is open with ISOPEN, 11-78

checking if temporary LOB is, 10-41

seeing if a LOB is open, 9-51

opening

BFILEs, 11-55

BFILEs using FILEOPEN, 11-57

BFILEs with OPEN, 11-62

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

internal LOB buffering, 3-35

modifying internal LOBs, 3-33

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

OraBfile example

OraBlob example

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

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

properties for operating on LOBs, 3-35

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

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

syntax reference, 3-30

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

OraclePreparedStatement, See JDBC

OracleResultSet, See JDBC

oracle.sql.BFILE

BFILE-buffering, 3-43

JDBC methods to read/examine BFILEs, 3-42

oracle.sql.BLOB

for modifying BLOB values, 3-39

reading/examining BLOB values, 3-39

See JDBC

oracle.sql.BLOBs

BLOB-buffering

oracle.sql.CLOB

CLOB-buffering

JDBC methods to read/examine CLOB values, 3-41

modifying CLOB values, 3-40

oracle.sql.CLOBs

See JDBC

---

P

pattern

check if it exists in BFILE using instr, 11-126

see if it exists IN LOB using (instr)

internal persistent LOBs, 9-128

temporary LOBs

checking if it exists, 10-82

PCTVERSION, 7-7

performance

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

OCI and temporary LOBs, 10-12

PL/SQL, 3-2

assigning one LOB to another, 10-110

performance when reassigning locators in temporary LOBs, 10-12

PL/SQL procedures

client-side cannot call DBMS_LOB, 4-16

polling, 9-65, 9-76, 9-103, 9-193, 10-152

Pro*C/C++ precompiler

available LOB functions, 3-3

LOB buffering, 3-25

locators, 3-24

modifying internal LOB values, 3-23

opening and closing internal LOBs and external LOBs (BFILEs), 3-25

providing an allocated input locator pointer, 3-22

reading or examining internal and external LOB values, 3-23

statements for BFILEs, 3-24

statements for temporary LOBs, 3-24

Pro*COBOL precompiler

available LOB functions, 3-3

LOB buffering, 3-29

locators, 3-29

modifying internal LOB values, 3-27

opening/closing internal LOBs and external LOBs (BFILEs), 3-29

providing an allocated input locator, 3-26

reading or examining internal and external LOBs, 3-28

statements for BFILEs, 3-28

temporary LOBs, 3-28

programmatic environments, 3-2

available functions, 3-3

compared, 3-3

---

R

read consistency

LOBs, 5-2

read consistent locators, 5-2, 5-3, 5-10, 5-13, 5-25, 5-28, 5-29, 5-30

reading

BFILES

specify 4 Gb-1 regardless of LOB, 11-99

data fom temporary LOB, 10-57

data from a LOB

internal persistent LOBs, 9-101

large amounts of LOB data using streaming, 9-65

portion of BFILE data using substr, 11-108

portion of LOB using substr

internal persistent LOBs, 9-112

portion of temporary LOB, 10-68

small amounts of data,enable buffering, 9-239

reference semantics, 2-3, 9-27

BFILEs enables multiple BFILE columns per record, 11-7

restrictions

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

binds of more than 4000 bytes, 7-18

roundtrips to the server, avoiding, 5-21, 5-28

---

S

sample programs, 1-5

security

BFILEs, 11-8, 11-9

BFILEs using SQL DDL, 11-10

BFILEs using SQL DML, 11-10

SELECT statement

FOR UPDATE, 2-7

read consistency, 5-2

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

semantics

copy-based for internal LOBs, 9-27

pseudo-reference, 10-10

reference based for BFILEs, 11-7

value, 10-10

SESSION_MAX_OPEN_FILES parameter, 4-2, 11-56, 11-70

setData

setting to EMPTY_BLOB() using JPublisher, 6-9

setting

internal LOBs to empty, 2-9

LOBs to NULL, 2-8

overides for NLS_LANG variable

SQL DDL

BFILE security, 11-10

SQL DML

BFILE security, 11-10

SQL Loader

loading InLine LOB data, 4-7

performance for internal LOBs, 4-6

stream

reading

temporary LOBs, 10-58

writing, 10-152

streaming, 9-76, 9-91

do not enable buffering, when using, 9-239

write, 9-202

system owned object, See DIRECTORY object

---

T

tablespace

temporary, 10-8

temporary LOB data stored in temporary, 10-7

temporary LOBs

character set ID, 10-127

checking if LOB is temporary, 10-22

data stored in temporary tablespace, 10-7

DBMS_LOB available functions/procedures, 3-8

disable buffering

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

features, 10-10

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

lifetime and duration, 10-8

locators can be IN values, 10-6

locators operate as with permanent LOBs, 10-6

memory handling, 10-8

OCI and logical buckets, 10-8

OCI functions, 3-15

performance, 10-10

Pro*C/C++ precompiler embedded SQL statements, 3-24

Pro*COBOL precompiler statements, 3-28

reside on server not client, 10-8

similar functions used to permanent LOBs, 10-7

SQL DML does not operate on, 10-6

transactions and consistent reads not suuported, 10-7

trimming, 10-162

write append to, 10-143

temporary tablespace

for binds of more than 4000 bytes, 7-16

TO_LOB

limitations, 9-60

transaction boundaries

LOB locators, 5-16

transactions

external LOBs do not participate in, 2-3

IDs of locators, 5-16

internal LOBs participate fully, 2-2

LOB locators cannot span, 5-13

LOBs locators cannot span, 7-15

locators with non-serializable, 5-16

locators with serializable, 5-16

migrating from, 5-26

triggers

LOB columns with, how to tell when updated, 6-4

trimming

LOB data

internal persistent LOBs, 9-218

temporary LOB data, 10-162

---

U

unstructured data, 1-2

UPDATE statements

binds of greater than 4000 bytes, 7-16

updated locators, 5-2, 5-5, 5-10, 5-13, 5-25

updating

a row containing a BFILE, 11-181

avoid the LOB with different locators, 5-8

BFILEs by selecting a BFILE from another table, 11-185

BFILEs using BFILENAME(), 11-182

by initializinga LOB locator bind variable

internal persistent LOBs, 9-265

by selecting a LOB from another table

internal persistent LOBs, 9-263

LOB with PL/SQL bind variable, 5-10

locking before, 9-144

locking prior to, 9-183, 9-219, 9-229

with EMPTY_CLOB()/EMPTY_BLOB()

internal persistent LOBs, 9-260

use cases

full list of internal persistent LOBs, 9-2

how to interpret the diagrams, l

model, graphic summary of, 9-1

---

V

value of LOBs, 2-5

VARRAYs

LOBS are not supported by, 4-15

See creating VARRAYs

varying-width character data, 2-4

views on DIRECTORY object, 11-10

Visual Basic, See Oracle Objects for OLE(OO4O)

---

W

write

streaming, 10-152

write appending

to temporary LOBs, 10-143

writing

data to a LOB

internal persistent LOBs, 9-201

data to a temporary LOB, 10-151

singly or piecewise, 9-193

small amounts of data, enable buffering, 9-239