SUBSTR v16

The SUBSTR function returns a portion of a large object.

<data> { RAW | VARCHAR2 } SUBSTR(<lob_loc> { BLOB | CLOB }
   [, <amount> INTEGER [, <offset> INTEGER ]])

Parameters

lob_loc

Large object locator of the large object to read.

amount

Number of bytes/characters to return. Default is 32,767.

offset

Position in the large object to begin returning data. The first byte/character is position 1. The default is 1.

data

Returned portion of the large object to read. If lob_loc is a BLOB, the return data type is RAW. If lob_loc is a CLOB, the return data type is VARCHAR2.

• On this page
• Parameters