15.120 SEM_APIS.LOAD_INTO_STAGING_TABLE
Format
SEM_APIS.LOAD_INTO_STAGING_TABLE( stagong_table IN VARCHAR2, source_table IN VARCHAR2, input_format IN VARCHAR2 DEFAULT NULL, parallel IN INTEGER DEFAULT NULL, staging_table_owner IN VARCHAR2 DEFAULT NULL, source_table_owner IN VARCHAR DEFAULT NULL, flags IN VARCHAR DEFAULT NULL);
Description
Loads data into a staging table from an external table mapped to an N-Triple or N-Quad format input file.
Parameters
- staging_table
-
Name of the staging table.
- source_table
-
Name of the source external table.
- input_format
-
Format of the input file mapped by the source external table:
N-TRIPLE
orN-QUAD
- parallel
-
Degree of parallelism to use during the load.
- staging_table_owner
-
Owner for the staging table being created. If not specified, the invoker is assumed to be the owner.
- source_table_owner
-
Owner for the source table. If not specified, the invoker is assumed to be the owner.
- flags
-
(Reserved for future use)
Usage Notes
For more information and an example, see Loading N-Quad Format Data into a Staging Table Using an External Table.
Examples
The following example loads the staging table. (This example is an excerpt from Example 1-109 in Loading N-Quad Format Data into a Staging Table Using an External Table.)
BEGIN sem_apis.load_into_staging_table( staging_table => 'STAGE_TABLE' ,source_table => 'stage_table_source' ,input_format => 'N-QUAD'); END;
Parent topic: SEM_APIS Package Subprograms