15.164 SEM_APIS.VALUE_NAME_SUFFIX
Format
SEM_APIS.VALUE_NAME_SUFFIX ( value_name IN VARCHAR2, value_type IN VARCHAR2 ) RETURN VARCHAR2;
Description
Returns the value in the VNAME_SUFFIX column for the specified value name and value type pair in the RDF_VALUE$ table.
Parameters
- value_name
-
Value name. Must match a value in the VALUE_NAME column in the RDF_VALUE$ table, which is described in Statements.
- value_type
-
Value type. Must match a value in the VALUE_TYPE column in the RDF_VALUE$ table, which is described in Statements.
Usage Notes
This function usually causes an index on the RDF_VALUE$ table to be used for processing a lookup for values, and thus can make a query run faster.
Examples
The following query returns value name portions of all the lexical values in RDF_VALUE$ table with a suffix value same as that returned by the VALUE_NAME_SUFFIX function. This query uses an index on the RDF_VALUE$ table, thereby providing efficient lookup.
SELECT value_name FROM RDF_VALUE$ WHERE vname_suffix = SEM_APIS.VALUE_NAME_SUFFIX( 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type','UR'); VALUE_NAME -------------------------------------------------------------------------------- http://www.w3.org/1999/02/22-rdf-syntax-ns#type
Parent topic: SEM_APIS Package Subprograms