Oracle Data Type Explanation. ANYONE ????

[DukeNukem]

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]

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.