TRIM procedures - Truncate a large object to the specified length

The TRIM procedures provide the capability to truncate a large object to the specified length.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_LOB.TRIM_BLOB( lob_loc,newlen)
Read syntax diagramSkip visual syntax diagramDBMS_LOB.TRIM_CLOB( lob_loc,newlen)

Parameters

lob_loc
An input or output argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object to be trimmed.
newlen
An input argument of type INTEGER that specifies the new number of bytes or characters to which the large object is to be trimmed.

Authorization

EXECUTE privilege on the DBMS_LOB module.