DIGIT-ARC read-only archive · snapshot: July 23, 2026

DIGIT-ARC / Internet and Networking / Networking

Oracle Data Type Explanation. ANYONE ????

2 posts · originally from https://geek.digit.in/community/threads/oracle-data-type-explanation-anyone.35636/

DukeNukem
DukeNukem Original post #1
Sep 4, 2006 at 10:03 AM
Hye angels,

You use the BLOB datatype to store large binary objects in the database in-line or out-of-line.

What does "database in-line or out-of-line" mean Here


Can any one tell/explain me.


Thanks


------------------------------------------------------------------
Life is like a box of ammo
wizrulz
wizrulz #2
Sep 7, 2006 at 12:35 AM
In-line and Out-of-Line storage: ENABLE STORAGE IN ROW and DISABLE STORAGE IN ROW

ENABLE STORAGE IN ROW allows LOB data to be stored in the tablesegment provided it is less than4000 bytes.
DISABLE STORAGE IN ROW prevents LOB data from being stored in-line, regardless of the size of the LOB. Instead only a 20-byte LOB locator isstored with the other column data in the table segment.