Large Object Utilities
Large objects like CLOB/BLOB extra functions to help manage and convert data to/from.
lobSize
Returns the size of any BLOB/CLOB object as a BIGINT.
concat
Appends any character field (char/varchar/lvarchar) to a new CLOB object.
toClob
Converts any character field (char/varchar/lvarchar) into a CLOB.
append
Appends any character field (char/varchar/lvarchar) to an existing CLOB object.
toString
Returns the LVARCHAR characters from a CLOB. The CLOB must be 32,000 bytes or less in size.
Parent topic:
Extended Utilities
Copyright© 2021 HCL Technologies Limited