Example PL/SQL Block

DECLARE
  c_base_uri VARCHAR2(4000) := '<PAR URI>/<prefix>'; -- same PAR URI used for export
  c_table_list SYS.ODCIVARCHAR2LIST := SYS.ODCIVARCHAR2LIST('ITEM_LOC_SOH_EOD', 'ITEM_LOC_SOH', 'ITEM_LOC');
  l_columnpath CLOB;
BEGIN
  FOR i IN 1 .. c_table_list.COUNT LOOP
    -- To guarantee a specific ordering of columns, use the ORDER BY 
    -- clause within the JSON_ARRAYAGG function. Column order in
    -- columnpath must match table column ordering.  First column in
    -- columnpath matches first column in table.
    SELECT JSON_ARRAYAGG('$.' || column_name) 
      WITHIN GROUP (ORDER BY column_id)
      INTO l_columnpath
    FROM user_tab_columns
    WHERE table_name = c_table_list(i);
     
    DBMS_OUTPUT.PUT_LINE('Importing ' || c_table_list(i) || ' to uri: ' || c_base_uri || '/' || LOWER(c_table_list(i)));
    DBMS_CLOUD.COPY_DATA(
      table_name      => c_table_list(i),
      credential_name => NULL,
      file_uri_list   => c_base_uri || '/' || LOWER(c_table_list(i)) || '*',
      format          => JSON_OBJECT('type' VALUE 'json', 'columnpath' VALUE l_columnpath)
    );
  END LOOP;
END;