|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Internal Persistent LOBs, 43 of 43
"Use Case Model: Internal Persistent LOBs Operations", for all Internal Persistent LOB operations.
This procedure describes how to delete the row of a table containing a LOB.
To delete a row that contains an internal
LOB column or attribute use one of the following commands
In either case you delete the
LOB locator and the LOB value as well.
Due to the consistent read mechanism, the old
Of course, two distinct rows of a table with a
LOB column have their own distinct
LOB locators and distinct copies of the
LOB values irrespective of whether the
LOB values are the same or different. This means that deleting one row has no effect on the data or
LOB locator in another row even if one
LOB was originally copied from another row.
Use the following syntax reference:
In the three examples provided in the following section, all data associated with Clip 10 is deleted.
The examples are provided in SQL and apply to all programmatic environments: