15.163 SEM_APIS.VALUE_NAME_PREFIX
Format
SEM_APIS.VALUE_NAME_PREFIX ( value_name IN VARCHAR2, value_type IN VARCHAR2 ) RETURN VARCHAR2;
Description
Returns the value in the VNAME_PREFIX 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 prefix value same as that returned by the VALUE_NAME_PREFIX function. This query uses an index on the RDF_VALUE$ table, thereby providing efficient lookup.
SELECT value_name FROM RDF_VALUE$ WHERE vname_prefix = SEM_APIS.VALUE_NAME_PREFIX( 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type','UR'); VALUE_NAME -------------------------------------------------------------------------------- http://www.w3.org/1999/02/22-rdf-syntax-ns#Alt http://www.w3.org/1999/02/22-rdf-syntax-ns#Bag http://www.w3.org/1999/02/22-rdf-syntax-ns#List http://www.w3.org/1999/02/22-rdf-syntax-ns#Property http://www.w3.org/1999/02/22-rdf-syntax-ns#Seq http://www.w3.org/1999/02/22-rdf-syntax-ns#Statement http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral http://www.w3.org/1999/02/22-rdf-syntax-ns#first http://www.w3.org/1999/02/22-rdf-syntax-ns#nil http://www.w3.org/1999/02/22-rdf-syntax-ns#object http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate http://www.w3.org/1999/02/22-rdf-syntax-ns#rest http://www.w3.org/1999/02/22-rdf-syntax-ns#subject http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.w3.org/1999/02/22-rdf-syntax-ns#value 15 rows selected.
Parent topic: SEM_APIS Package Subprograms