Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Modeling and Design
This chapter discusses the following topics:
Selecting a Datatype
LOBs Compared to LONG and LONG RAW Types
Character Set Conversions: Working with Varying-Width and Multibyte Fixed-Width Character Data
Selecting a Table Architecture
Where are NULL Values in a LOB Column Stored?
Defining Tablespace and Storage Characteristics for Internal LOBs
LOB Storage Characteristics for LOB Column or Attribute
TABLESPACE and LOB Index
How to Create Gigabyte LOBs
LOB Locators and Transaction Boundaries
Binds Greater Than 4,000 Bytes in INSERTs and UPDATEs
OPEN, CLOSE, and ISOPEN Interfaces for Internal LOBs
LOBs in Index Organized Tables (IOT)
Manipulating LOBs in Partitioned Tables
Indexing a LOB Column
SQL Semantics Support for LOBs
User-Defined Aggregates and LOBs
Copyright © 1996-2001, Oracle Corporation.
All Rights Reserved.