15.71 SEM_APIS.DROP_RESULT_TAB
Format
SEM_APIS.DROP_RESULT_TAB ( query_pattern_type IN NUMBER, result_tab_name IN VARCHAR2, rdf_graph_name IN VARCHAR2, options IN VARCHAR2 DEFAULT NULL, network_owner IN DBMS_ID DEFAULT NULL, network_name IN VARCHAR2 DEFAULT NULL);
Description
Drops result table(s) defined on a given RDF graph.
Parameters
- query_pattern_type
-
Type of the result table.
The value can be one of the following:SEM_APIS.SPM_TYPE_SVP
SEM_APIS.SPM_TYPE_MVP
SEM_APIS.SPM_TYPE_PCN
SEM_APIS.SPM_TYPE_ALL
Use of
SEM_APIS.SPM_TYPE_ALL
indicates that the target result tables can be of any type.
- result_tab_name
-
String for use as part of the name of the result table. If the target is an MVP table, then specify the name of the property. Use of the value ‘
*
’ indicates that the target is the set of all the result tables of the type specified by thespm_type
parameter. - rdf_graph_name
-
Name of the RDF graph.
- options
-
Reserved for future use.
- network_owner
-
Owner of the RDF network. (See Table 1-2.)
- network_name
-
Name of the RDF network. (See Table 1-2.)
Usage Notes
- This operation has a DDL semantics.
- The invoker must be the owner of the target RDF graph or the RDF network or both.
Examples
The following example drops a specific SVP table named FLHF
:
BEGIN
SEM_APIS.DROP_RESULT_TAB(
query_pattern_type => SEM_APIS.SPM_TYPE_SVP
, result_tab_name => 'FLHF'
, rdf_graph_name => 'M1'
, network_owner => 'RDFUSER'
, network_name => 'NET1'
);
END;
/
The following example drops all the currently existing result tables on RDF graph
M1
:
BEGIN
SEM_APIS.DROP_RESULT_TAB(
query_pattern_type => SEM_APIS.SPM_TYPE_ALL
, resulrdf_graph_name => 'M1'
, network_owner => 'RDFUSER'
, network_name => 'NET1'
);
END;
/
Parent topic: SEM_APIS Package Subprograms