its affiliates 31 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] 2021/10