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