Ken wrote:
>>A LOB instance has a locator and a value. The LOB locator is a reference
>>to where the LOB value is physically stored. The LOB value is the data
>>stored in the LOB. Every LOB you insert will have a diffrent locator
>>referencing it!
>>
>>To add more, you can choose if the LOB is stored inline(in the same
>>tablespace as other rows in the table, or simply put 'inside the same
>>row') or as an 'outline' LOB, where a LOB locator would reference the
>>LOB(and the LOB content is/may stored in a diffrent tablespace). Oracle
>>would automatically store a LOB as an outline LOB, when the size is more
>>than a specific value.
>>
>>Amogh
>
> Amogh,
>
> I still have confusion. Perhaps use a sample code:
> DECLARE
> v_bl BLOB;
> BEGIN
> SELECT bl_col INTO v_bl FROM table WHERE pk=1;
> INSERT INTO table (pk,bl_col) VALUES (2, v_bl);
> END;
>
> For the row created by the insert statement (with pk=2), would the bl_col
> referencing the same BLOB object as the row with pk=1?
>
> Thx
>
>
No, it will not.
Received on Fri Jul 22 2005 - 11:17:15 CDT
