SUBSTR function
The SUBSTR function provides the capability to return a portion of a large object.
The function returns a BLOB(32767) (for a BLOB) or VARCHAR (for a CLOB) value for the returned portion of the large object read by the function.
Syntax
SUBSTR(lob_loc
[ ,amount
[ ,offset ]
]
)
Parameters
- lob_loc
- An input argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object to be read.
- amount
- An optional input argument of type INTEGER that specifies the number of bytes or characters to be returned. The default value is 32,767.
- offset
- An optional input argument of type INTEGER that specifies the position within the large object to begin returning data. The first byte or character is at position 1. The default value is 1.