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 the spm_type parameter.

rdf_graph_name

Name of the RDF graph.

options

Reserved for future use.

network_owner

Owner of the RDF network. (See Table: network_owner and network_name Parameters.)

network_name

Name of the RDF network. (See Table: network_owner and network_name Parameters.)

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
   , rdf_graph_name       => 'M1'
   , network_owner        => 'RDFUSER'
   , network_name         => 'NET1'
  );
END;
/