Fixed Width Data Copyright © 2021, Oracle and/or its affiliates 37 BEGIN DBMS_CLOUD.CREATE_EXTERNAL_TABLE( table_name => '<YOUR_TABLE_NAME>' , credential_name => '<YOUR_CREDENTIAL_NAME>' , file_uri_list => '<YOUR_ORACLE_OBJECT_STORE_URL>' , format => json_object('trimspaces' value 'rtrim','skipheaders' value '1', 'dateformat' value 'YYYYMMDD') , field_list => 'object_id (1:3) char , object_name (4:14) char , object_type (15:39) char , created_date1 (40:45) date mask "YYMMDD" , created_date2 (46:53) date , last_ddl_time (54:61) date , status (62:71)' , column_list => 'object_id number , object_name varchar2(30) , object_type varchar2(25) , status varchar2(10) , created_date1 date , created_date2 date , last_ddl_time date'); END; / 固定⻑ファイル 2021/8