15.153 SEM_APIS.UNESCAPE_CLOB_VALUE
Format
SEM_APIS.UNESCAPE_CLOB_VALUE( val IN CLOB CHARACTER SET ANY_CS, start_offset IN NUMBER DEFAULT 1, end_offset IN NUMBER DEFAULT 0, include_start IN NUMBER DEFAULT 0, options IN VARCHAR2 DEFAULT NULL, max_vc_len IN NUMBER DEFAULT 4000 ) RETURN VARCHAR2 CHARACTER SET val%CHARSET;
Description
Returns the input CLOB value with special characters and non-ASCII characters unescaped as specified by the W3C N-Triples format (http://www.w3.org/TR/rdf-testcases/#ntriples
).
Parameters
- val
-
The CLOB text to unescape.
- start_offset
-
The offset in
val
from which to start character unescaping. The default (1) causes escaping to start at the first character ofval
. - end_offset
-
The offset in
val
from which to end character unescaping. The default (0) causes escaping to continue through the end ofval
. - include_start
-
Set to 1 if the characters in val from 1 to
start_offset
should be prefixed (prepended) to the return value. Otherwise, no such characters will be prefixed to the return value. - options
-
Reserved for future use.
- max_vc_len
-
The maximum allowed length of a VARCHAR RDF term - 32767 or 4000 (the default).
Usage Notes
For information about using the DO_UNESCAPE
keyword in the options
parameter of the SEM_MATCH table function, see Using the SEM_MATCH Table Function to Query Semantic Data.
Examples
The following example unescapes an input character string containing TAB and NEWLINE characters.
SELECT SEM_APIS.UNESCAPE_CLOB_VALUE('abc\tdef\nhij') FROM DUAL;
Parent topic: SEM_APIS Package Subprograms