There are two ways to create an external table in an Autonomous Database using a Pre-Authenticated Request (PAR) URL:

• Use a single Autonomous Database Pre-Authenticated Request (PAR) URL to create an external table. After the table is created, you can read data from the table using the SELECT statement. You can also apply filters and clauses when retrieving data from the table. For example, you can filter the data with the WHERE clause or sort it using the ORDER BY clause.

  Example to create an external table over a single PAR URL:

  DBMS_CLOUD.CREATE_EXTERNAL_TABLE (
     table_name => 'ext_tab_parurl',
     file_uri_list => 'https://dataaccess.adb.us-chicago-1.oraclecloudapps.com/adb/p/K6XExample/data'
  );
  END;
  /

  After the table is created, you can query the table using the SELECT statement, and you can also filter or sort the output. Example to read data from the ext_tab_parurl table in descending order:

  SELECT * FROM ext_tab_parurl 
     ORDER BY height DESC;
  
  COUNTY    SPECIES      HEIGHT
  ------    ----------   -------
  First     Chestnut      51
  Main      Alder         45
  Main      Douglas-fir   34
  Main      Pine          29
  Main      Cedar         21
  

• Use a comma-delimited list of Autonomous Database Pre-Authenticated Request (PAR) URLs, you must ensure that all included PAR URLs must have the same column names, column order, and column data types in the same schema.

  Example to create an external table over a list of PAR URLs:

  DBMS_CLOUD.CREATE_EXTERNAL_TABLE (
     table_name => 'ext_tab_parurl_1',
     file_uri_list => 'https://dataaccess.adb.us-chicago-1.oraclecloudapps.com/adb/p/K6XExample/data',
                      'https://dataaccess.adb.us-chicago-1.oraclecloudapps.com/adb/p/K7XExample/data'
  );
  END;
  /

  Query the table using the SELECT statement:

  SELECT * FROM ext_tab_parurl_1;
  
  COUNTY   SPECIES      HEIGHT
  ------   ----------   -------
  First     Chestnut      51
  Main      Alder         45
  Main      Douglas-fir   34
  Main      Pine          29
  Main      Cedar         21
  Main      Aspen         35
  First     Maple         16
  

The parameters are:

• table_name: is the external table name.

• file_uri_list: is either a single Pre-Authenticated Request (PAR) URL or a comma-delimited list of Pre-Authenticated Request (PAR) URLs.