Search notes:

Oracle: DBMS_LOB.SUBSTR

dbms_lob.substr returns a substring of a clob as a varchar2.

For a blob, it returns the specified bytes as a raw.

Note: Unlike in the SQL function substr, the number of characters (or bytes) to be removed is the second (not the third), the offset is the third (not the second) parameter:

dbms_lob.substr (
   lob_locator,
   amount,
   offset
)

Oracle: DBMS_LOB.SUBSTR

See also