This illustration shows the use case Update the Row or Entire LOB Data in the Internal Persistent LOB Interface.

There are three ways to update the row or entire LOB data:

  1. Update using the function Empty_CLOB() or Empty_BLOB()
  2. Update as SELECT
  3. Update by initializing a LOB locator bind variable