TRIM procedures

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

Syntax


1  TRIM_BLOB ( lob_loc , newlen )

1  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.