Slide 64
Slide 64 text
Import JSON Data from Cloud Object Store
オブジェクトストレージから既存の表へのJSONデータのロード
DBMS_CLOUD.COPY_COLLECTIONでのロード以外に、DBMS_CLOUD.COPY_DATAを利用してオブジェクトスト
レージ上のJSONデータを表にロードできるようになりました。リソースプリンシパルを利用したOCIオブジェクトストレージへの
アクセス、ARNによるAWS S3へのアクセスも可能です。
2021/10
CREATE TABLE EMPTEST(EMPNO NUMBER(4),ENAME VARCHAR2(10));
BEGIN
DBMS_CLOUD.COPY_DATA(
table_name => 'EMPTEST',
credential_name => ‘DEF_CRED_ADMIN',
file_uri_list => 'https://objectstorage.ap-tokyo-
1.oraclecloud.com/n/namespace/b/bucketname/o/emp.json',
format => JSON_OBJECT('type' value 'json', 'columnpath' value
'["$.EMPNO","$.ENAME"]')
);
END;
/
SELECT * FROM EMPTEST;
EMPNO ENAME
---------- ----------
7369 SMITH
7900 JAMES
{"ENAME":"SMITH","JOB":"CLERK","MGR":"7902","HIREDATE":"1980-12-
17","SAL":"800.00","COMM":"0.00","DEPTNO":"20","EMPNO":7369}{"ENAM
E":"JAMES","JOB":"CLERK","MGR":"7698","HIREDATE":"1981-12-
03","SAL":"950.00","COMM":"0.00","DEPTNO":"30","EMPNO":7900}{"ENAM
E":"ADAMS","JOB":"CLERK","MGR":"7788","HIREDATE":"1983-01-
12","SAL":"1100.00","COMM":"0.00","DEPTNO":"20","EMPNO":7876}{"ENAM
E":"WARD","JOB":"SALESMAN","MGR":"7698","HIREDATE":"1981-02-
22","SAL":"1250.00","COMM":"500.00","DEPTNO":"30","EMPNO":7521}
[emp.json]
Copyright © 2022, Oracle and/or its affiliates |
64