TRIM v13

The TRIM procedure provides the capability to truncate a large object to the specified length.

TRIM(<lob_loc> IN OUT { BLOB | CLOB }, <newlen> INTEGER)

Parameters

lob_loc

Large object locator of the large object to be trimmed.

newlen

Number of bytes/characters to which the large object is to be trimmed.