TRIM v17

The TRIM procedure truncates a large object to the specified length.

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

Parameters

lob_loc

Large object locator of the large object to trim.

newlen

Number of bytes/characters to which you want to trim the large object.