SUBSTR v15
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