BEGIN
DBMS_CLOUD.EXPORT_DATA
(
file_uri_list => 'export_dir:sales.csv',
format => JSON_OBJECT('type' value 'csv'),
query => 'SELECT * FROM sales'
);
END;
/
BEGIN
DBMS_CLOUD.EXPORT_DATA
(
file_uri_list => '"export_dir":sales.xml',
format => JSON_OBJECT('type' value 'xml'),
query => 'SELECT * FROM sales'
);
END;
/
The parameters are:
-
file_uri_list
: is a comma delimited list of the export file(s). Use of wildcard and substitution characters is not supported in the file_uri_list
.
-
format
: specifies the required type
parameter. The valid values are datapump
, json
, xml
, csv
and parquet
and it also optionally defines the options you can specify for the export with the ORACLE_DATAPUMP
Access Driver.
-
query
: specifies a SELECT
statement so that only the required data is exported. The query determines the contents of the dump file(s).
Note
The DBMS_CLOUD.EXPORT_DATA
procedure creates the dump file(s) that you specify in the file_uri_list
. The procedure does not overwrite files. If a dump file in the file_uri_list
exists, DBMS_CLOUD.EXPORT_DATA
generates another file with a unique name. DBMS_CLOUD.EXPORT_DATA
does not create directories.
For detailed information about the parameters, see EXPORT_DATA Procedure.