[5/28/2024, 5:48:18 PM] [Worksheet       ] [INFO ] Action details
{
  "action": "Attach",
  "message": "Attached",
  "connection": {
    "name": "AU-APEX_USER",
    "href": "http://localhost:65416/20221610/databases/connections/definitions/AU-APEX_USER"
  },
  "session": "http://localhost:65416/20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/",
  "worksheet": {
    "name": "/AU-APEX_USER/object/APEX_USER/TABLE/STATIC_FILES",
    "state": "attached",
    "saved": true
  }
}
[5/28/2024, 5:48:18 PM] [DBToolsServerApp(10812)] [DEBUG] POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1
Host: localhost
Request-Id: 9oX9Q79pvV-XAN5ikMgVTw
Accept: application/json
Authorization: Signature key***M0g=="
Content-Length: 300
Content-Type: application/json
x-content-sha256: bvqMSwJoqayerMNUoukYWQj8eBzUY/cmbg6EW7ja4NI=
x-date: Tue, 28 May 2024 15:48:18 GMT
User-Agent: node-fetch/1.0 (+https://github.com/bitinn/node-fetch)
Accept-Encoding: gzip,deflate
Connection: close

{
    "statementText": "SELECT COLUMN_NAME\n      FROM SYS.ALL_TAB_COLUMNS\n      WHERE OWNER = :SCHEMA\n      AND TABLE_NAME = :PARENT_NAME\n      ORDER BY COLUMN_ID",
    "binds": [
        {
            "name": "SCHEMA",
            "value": "APEX_USER",
            "dataType": "VARCHAR2"
        },
        {
            "name": "PARENT_NAME",
            "value": "STATIC_FILES",
            "dataType": "VARCHAR2"
        }
    ],
    "fetchSize": -1,
    "limit": 0,
    "lineSize": 32767,
    "historyMode": "IGNORE"
}
[5/28/2024, 5:48:18 PM] [DBToolsServerApp(10812)] [DEBUG] POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1
Host: localhost
Request-Id: 1pZ_Ra_7a6qpeD1zo0bO2A
Accept: application/json
Authorization: Signature key***YBQ=="
Content-Length: 317
Content-Type: application/json
x-content-sha256: 1zBOwX7GxAuTBYLsFVTp3mX3Q/JnuKlHe5HI/Asoa9o=
x-date: Tue, 28 May 2024 15:48:18 GMT
User-Agent: node-fetch/1.0 (+https://github.com/bitinn/node-fetch)
Accept-Encoding: gzip,deflate
Connection: close

{
    "statementText": "SELECT PARTITION_NAME\n      FROM SYS.ALL_TAB_PARTITIONS\n      WHERE TABLE_OWNER = :SCHEMA\n      AND TABLE_NAME = :PARENT_NAME\n      ORDER BY PARTITION_NAME",
    "binds": [
        {
            "name": "SCHEMA",
            "value": "APEX_USER",
            "dataType": "VARCHAR2"
        },
        {
            "name": "PARENT_NAME",
            "value": "STATIC_FILES",
            "dataType": "VARCHAR2"
        }
    ],
    "fetchSize": -1,
    "limit": 0,
    "lineSize": 32767,
    "historyMode": "IGNORE"
}
[5/28/2024, 5:48:18 PM] [DBToolsServerApp(10812)] [DEBUG] HTTP/1.1 200 OK
Content-Type: application/json
Request-Id: 1pZ_Ra_7a6qpeD1zo0bO2A
Link: <http://localhost:65416/20221610/tasks/YwEIrb_BAkc-mFk_BT_aZg/> ; rel="dbtools:rel:task"

{
    "env": {
        "defaultTimeZone": "Z"
    },
    "items": [
        {
            "statementId": 1,
            "statementType": "query",
            "statementPos": {
                "startLine": 0,
                "endLine": 5
            },
            "statementText": "SELECT PARTITION_NAME\n      FROM SYS.ALL_TAB_PARTITIONS\n      WHERE TABLE_OWNER = :SCHEMA\n      AND TABLE_NAME = :PARENT_NAME\n      ORDER BY PARTITION_NAME",
            "resultSet": {
                "metadata": [
                    {
                        "columnName": "PARTITION_NAME",
                        "columnTypeName": "VARCHAR2",
                        "precision": 128,
                        "scale": 0,
                        "isNullable": 1
                    }
                ],
                "items": [
                    
                ],
                "count": 0
            },
            "response": [
                
            ]
        }
    ]
}
[5/28/2024, 5:48:18 PM] [DBToolsServerApp(10812)] [DEBUG] HTTP/1.1 200 OK
Content-Type: application/json
Request-Id: 9oX9Q79pvV-XAN5ikMgVTw
Link: <http://localhost:65416/20221610/tasks/o2i4cl0mv3mJ4gGe-y95zg/> ; rel="dbtools:rel:task"

{
    "env": {
        "defaultTimeZone": "Z"
    },
    "items": [
        {
            "statementId": 1,
            "statementType": "query",
            "statementPos": {
                "startLine": 0,
                "endLine": 5
            },
            "statementText": "SELECT COLUMN_NAME\n      FROM SYS.ALL_TAB_COLUMNS\n      WHERE OWNER = :SCHEMA\n      AND TABLE_NAME = :PARENT_NAME\n      ORDER BY COLUMN_ID",
            "resultSet": {
                "metadata": [
                    {
                        "columnName": "COLUMN_NAME",
                        "columnTypeName": "VARCHAR2",
                        "precision": 128,
                        "scale": 0,
                        "isNullable": 0
                    }
                ],
                "items": [
                    {
                        "COLUMN_NAME": "MODULE"
                    },
                    {
                        "COLUMN_NAME": "FILENAME"
                    },
                    {
                        "COLUMN_NAME": "CONTENT"
                    },
                    {
                        "COLUMN_NAME": "MIMETYPE"
                    },
                    {
                        "COLUMN_NAME": "MODIFIED"
                    },
                    {
                        "COLUMN_NAME": "FILE_VERSION"
                    }
                ],
                "count": 6
            },
            "response": [
                
            ]
        }
    ]
}
2024-05-28T15:48:18.516Z DEBUG   - - - [28/May/2024:15:48:18 +0000] "POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1" 200 - "-" "-" 108
[5/28/2024, 5:48:18 PM] [DBToolsServerApp(10812)] [DEBUG] - - - [28/May/2024:15:48:18 +0000] "POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1" 200 - "-" "-" 108
[5/28/2024, 5:48:19 PM] [DBToolsServerApp(10812)] [DEBUG] POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1
Host: localhost
Request-Id: nNRHf73Oy-miwj-t_shh6g
Accept: application/json
Authorization: Signature key***F2w=="
Content-Length: 2360
Content-Type: application/json
x-content-sha256: ztPU6FDBQWJfOgwgMio8yT9CKCbG2+DNVy8BQDF1jyM=
x-date: Tue, 28 May 2024 15:48:19 GMT
User-Agent: node-fetch/1.0 (+https://github.com/bitinn/node-fetch)
Accept-Encoding: gzip,deflate
Connection: close

{
    "statementText": "select c.column_name,  case when data_type = 'CHAR'     then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\twhen data_type = 'VARCHAR'  then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\twhen data_type = 'VARCHAR2' then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\twhen data_type = 'NCHAR'    then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\twhen data_type = 'NUMBER' then      \n\t\t\t\t\t\t\t\t    \tcase when c.data_precision is null and c.data_scale is null then          'NUMBER' \n\t\t\t\t\t\t\t\t    \twhen c.data_precision is null and c.data_scale is not null then          'NUMBER(38,'||c.data_scale||')' \n\t\t\t\t\t\t\t\t\t    else           data_type||'('||c.data_precision||','||c.data_SCALE||')'      end    \n    \t\t\t\t\t\t\twhen data_type = 'NVARCHAR' then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\twhen data_type = 'NVARCHAR2' then     data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\telse      data_type    end data_type,\n      decode(nullable,'Y','Yes','No') nullable,  \n    c.DATA_DEFAULT,column_id,   com.comments\t     \n      from sys.all_tab_Columns c, \n           sys.all_col_comments com\n      where c.owner      = :OBJECT_OWNER  \n      and  c.table_name =  :OBJECT_NAME   \n      and c.table_name = com.table_name\n      and c.owner = com.owner\n      and c.column_name = com.column_name\t              \n      order by column_id ",
    "binds": [
        {
            "name": "SCHEMA",
            "value": "APEX_USER",
            "dataType": "VARCHAR2"
        },
        {
            "name": "OBJECT_OWNER",
            "value": "APEX_USER",
            "dataType": "VARCHAR2"
        },
        {
            "name": "CONNECTION_NAME",
            "value": "AU-APEX_USER",
            "dataType": "VARCHAR2"
        },
        {
            "name": "CONN_TYPE",
            "value": "Oracle",
            "dataType": "VARCHAR2"
        },
        {
            "name": "OBJECT_TYPE",
            "value": "TABLE",
            "dataType": "VARCHAR2"
        },
        {
            "name": "OBJECT_FOLDER_TYPE",
            "value": "TABLE",
            "dataType": "VARCHAR2"
        },
        {
            "name": "TYPE",
            "value": "TABLE",
            "dataType": "VARCHAR2"
        },
        {
            "name": "OBJECT_NAME",
            "value": "STATIC_FILES",
            "dataType": "VARCHAR2"
        },
        {
            "name": "OBJECT_ID",
            "value": "89323",
            "dataType": "NUMBER"
        }
    ],
    "fetchSize": -1,
    "limit": 100,
    "lineSize": 32767,
    "historyMode": "IGNORE"
}
[5/28/2024, 5:48:19 PM] [DBToolsServerApp(10812)] [DEBUG] HTTP/1.1 200 OK
Content-Type: application/json
Request-Id: nNRHf73Oy-miwj-t_shh6g
Link: <http://localhost:65416/20221610/tasks/ugogeAffbrWGv5QUBTKavA/> ; rel="dbtools:rel:task"

{
    "env": {
        "defaultTimeZone": "Z"
    },
    "items": [
        {
            "statementId": 1,
            "statementType": "query",
            "statementPos": {
                "startLine": 0,
                "endLine": 21
            },
            "statementText": "select c.column_name,  case when data_type = 'CHAR'     then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\twhen data_type = 'VARCHAR'  then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\twhen data_type = 'VARCHAR2' then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\twhen data_type = 'NCHAR'    then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\twhen data_type = 'NUMBER' then      \n\t\t\t\t\t\t\t\t    \tcase when c.data_precision is null and c.data_scale is null then          'NUMBER' \n\t\t\t\t\t\t\t\t    \twhen c.data_precision is null and c.data_scale is not null then          'NUMBER(38,'||c.data_scale||')' \n\t\t\t\t\t\t\t\t\t    else           data_type||'('||c.data_precision||','||c.data_SCALE||')'      end    \n    \t\t\t\t\t\t\twhen data_type = 'NVARCHAR' then      data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\twhen data_type = 'NVARCHAR2' then     data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'    \n    \t\t\t\t\t\t\telse      data_type    end data_type,\n      decode(nullable,'Y','Yes','No') nullable,  \n    c.DATA_DEFAULT,column_id,   com.comments\t     \n      from sys.all_tab_Columns c, \n           sys.all_col_comments com\n      where c.owner      = :OBJECT_OWNER  \n      and  c.table_name =  :OBJECT_NAME   \n      and c.table_name = com.table_name\n      and c.owner = com.owner\n      and c.column_name = com.column_name\t              \n      order by column_id",
            "resultSet": {
                "metadata": [
                    {
                        "columnName": "COLUMN_NAME",
                        "columnTypeName": "VARCHAR2",
                        "precision": 128,
                        "scale": 0,
                        "isNullable": 0
                    },
                    {
                        "columnName": "DATA_TYPE",
                        "columnTypeName": "VARCHAR2",
                        "precision": 211,
                        "scale": 0,
                        "isNullable": 1
                    },
                    {
                        "columnName": "NULLABLE",
                        "columnTypeName": "VARCHAR2",
                        "precision": 3,
                        "scale": 0,
                        "isNullable": 1
                    },
                    {
                        "columnName": "DATA_DEFAULT",
                        "columnTypeName": "LONG",
                        "precision": 2147483647,
                        "scale": 0,
                        "isNullable": 1
                    },
                    {
                        "columnName": "COLUMN_ID",
                        "columnTypeName": "NUMBER",
                        "precision": 0,
                        "scale": 0,
                        "isNullable": 1
                    },
                    {
                        "columnName": "COMMENTS",
                        "columnTypeName": "VARCHAR2",
                        "precision": 4000,
                        "scale": 0,
                        "isNullable": 1
                    }
                ],
                "items": [
                    {
                        "COLUMN_NAME": "MODULE",
                        "DATA_TYPE": "VARCHAR2(255 CHAR)",
                        "NULLABLE": "No",
                        "DATA_DEFAULT": null,
                        "COLUMN_ID": "1",
                        "COMMENTS": null
                    },
                    {
                        "COLUMN_NAME": "FILENAME",
                        "DATA_TYPE": "VARCHAR2(255 CHAR)",
                        "NULLABLE": "No",
                        "DATA_DEFAULT": null,
                        "COLUMN_ID": "2",
                        "COMMENTS": null
                    },
                    {
                        "COLUMN_NAME": "CONTENT",
                        "DATA_TYPE": "BLOB",
                        "NULLABLE": "Yes",
                        "DATA_DEFAULT": null,
                        "COLUMN_ID": "3",
                        "COMMENTS": null
                    },
                    {
                        "COLUMN_NAME": "MIMETYPE",
                        "DATA_TYPE": "VARCHAR2(80 CHAR)",
                        "NULLABLE": "Yes",
                        "DATA_DEFAULT": null,
                        "COLUMN_ID": "4",
                        "COMMENTS": null
                    },
                    {
                        "COLUMN_NAME": "MODIFIED",
                        "DATA_TYPE": "DATE",
                        "NULLABLE": "Yes",
                        "DATA_DEFAULT": null,
                        "COLUMN_ID": "5",
                        "COMMENTS": null
                    },
                    {
                        "COLUMN_NAME": "FILE_VERSION",
                        "DATA_TYPE": "VARCHAR2(128 CHAR)",
                        "NULLABLE": "Yes",
                        "DATA_DEFAULT": null,
                        "COLUMN_ID": "6",
                        "COMMENTS": null
                    }
                ],
                "limit": 100,
                "count": 6
            },
            "response": [
                
            ]
        }
    ]
}
[5/28/2024, 5:48:19 PM] [DBToolsServerApp(10812)] [DEBUG] - - - [28/May/2024:15:48:19 +0000] "POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1" 200 - "-" "-" 223
[5/28/2024, 5:48:23 PM] [DBToolsServerApp(10812)] [DEBUG] POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1
Host: localhost
Request-Id: sroxtmyR2ZfXJJCfRVwWAA
Accept: application/json
Authorization: Signature key***QuQ=="
Content-Length: 352
Content-Type: application/json
x-content-sha256: C9AEqyRaL9loOLbCcxM7zfVK7bngr8aDBIuFaA13Z3A=
x-date: Tue, 28 May 2024 15:48:23 GMT
User-Agent: node-fetch/1.0 (+https://github.com/bitinn/node-fetch)
Accept-Encoding: gzip,deflate
Connection: close

{
    "statementText": "\n    SELECT\n        column_name, data_type\n    FROM\n        sys.all_tab_columns\n    WHERE\n        owner = :OBJECT_OWNER\n    AND\n        table_name = :OBJECT_NAME;\n    ",
    "binds": [
        {
            "name": "OBJECT_OWNER",
            "value": "APEX_USER",
            "dataType": "VARCHAR2"
        },
        {
            "name": "OBJECT_NAME",
            "value": "STATIC_FILES",
            "dataType": "VARCHAR2"
        }
    ],
    "fetchSize": -1,
    "limit": 100,
    "lineSize": 32767,
    "historyMode": "IGNORE"
}
[5/28/2024, 5:48:23 PM] [DBToolsServerApp(10812)] [DEBUG] HTTP/1.1 200 OK
Content-Type: application/json
Request-Id: sroxtmyR2ZfXJJCfRVwWAA
Link: <http://localhost:65416/20221610/tasks/ra98xCwo-A5edz-JsRZQ0A/> ; rel="dbtools:rel:task"

{
    "env": {
        "defaultTimeZone": "Z"
    },
    "items": [
        {
            "statementId": 1,
            "statementType": "query",
            "statementPos": {
                "startLine": 1,
                "endLine": 8
            },
            "statementText": "    SELECT\n        column_name, data_type\n    FROM\n        sys.all_tab_columns\n    WHERE\n        owner = :OBJECT_OWNER\n    AND\n        table_name = :OBJECT_NAME",
            "resultSet": {
                "metadata": [
                    {
                        "columnName": "COLUMN_NAME",
                        "columnTypeName": "VARCHAR2",
                        "precision": 128,
                        "scale": 0,
                        "isNullable": 0
                    },
                    {
                        "columnName": "DATA_TYPE",
                        "columnTypeName": "VARCHAR2",
                        "precision": 128,
                        "scale": 0,
                        "isNullable": 1
                    }
                ],
                "items": [
                    {
                        "COLUMN_NAME": "FILE_VERSION",
                        "DATA_TYPE": "VARCHAR2"
                    },
                    {
                        "COLUMN_NAME": "MODULE",
                        "DATA_TYPE": "VARCHAR2"
                    },
                    {
                        "COLUMN_NAME": "FILENAME",
                        "DATA_TYPE": "VARCHAR2"
                    },
                    {
                        "COLUMN_NAME": "CONTENT",
                        "DATA_TYPE": "BLOB"
                    },
                    {
                        "COLUMN_NAME": "MIMETYPE",
                        "DATA_TYPE": "VARCHAR2"
                    },
                    {
                        "COLUMN_NAME": "MODIFIED",
                        "DATA_TYPE": "DATE"
                    }
                ],
                "limit": 100,
                "count": 6
            },
            "response": [
                
            ]
        }
    ]
}
[5/28/2024, 5:48:23 PM] [DBToolsServerApp(10812)] [DEBUG] - - - [28/May/2024:15:48:23 +0000] "POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1" 200 - "-" "-" 57
[5/28/2024, 5:48:23 PM] [DBToolsServerApp(10812)] [DEBUG] POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1
Host: localhost
Request-Id: IBN56cxSjrKocSlaRwzyuA
Accept: application/json
Authorization: Signature key***hDg=="
Content-Length: 369
Content-Type: application/json
x-content-sha256: uChtOvff7ot5bNMOxVVBrJ+SVBPf/HPoHr8vj0LOBH0=
x-date: Tue, 28 May 2024 15:48:23 GMT
User-Agent: node-fetch/1.0 (+https://github.com/bitinn/node-fetch)
Accept-Encoding: gzip,deflate
Connection: close

{
    "statementText": "\n    SELECT\n        COLUMN_NAME, INSERTABLE, UPDATABLE\n    FROM \n        all_updatable_columns \n    WHERE\n        owner = :OBJECT_OWNER \n    AND\n        table_name = :OBJECT_NAME;\n    ",
    "binds": [
        {
            "name": "OBJECT_OWNER",
            "value": "APEX_USER",
            "dataType": "VARCHAR2"
        },
        {
            "name": "OBJECT_NAME",
            "value": "STATIC_FILES",
            "dataType": "VARCHAR2"
        }
    ],
    "fetchSize": -1,
    "limit": 100,
    "lineSize": 32767,
    "historyMode": "IGNORE"
}
[5/28/2024, 5:48:23 PM] [DBToolsServerApp(10812)] [DEBUG] HTTP/1.1 200 OK
Content-Type: application/json
Request-Id: IBN56cxSjrKocSlaRwzyuA
Link: <http://localhost:65416/20221610/tasks/T6eQkxag884H7JwWsK_DGg/> ; rel="dbtools:rel:task"

{
    "env": {
        "defaultTimeZone": "Z"
    },
    "items": [
        {
            "statementId": 1,
            "statementType": "query",
            "statementPos": {
                "startLine": 1,
                "endLine": 8
            },
            "statementText": "    SELECT\n        COLUMN_NAME, INSERTABLE, UPDATABLE\n    FROM \n        all_updatable_columns \n    WHERE\n        owner = :OBJECT_OWNER \n    AND\n        table_name = :OBJECT_NAME",
            "resultSet": {
                "metadata": [
                    {
                        "columnName": "COLUMN_NAME",
                        "columnTypeName": "VARCHAR2",
                        "precision": 128,
                        "scale": 0,
                        "isNullable": 0
                    },
                    {
                        "columnName": "INSERTABLE",
                        "columnTypeName": "VARCHAR2",
                        "precision": 3,
                        "scale": 0,
                        "isNullable": 1
                    },
                    {
                        "columnName": "UPDATABLE",
                        "columnTypeName": "VARCHAR2",
                        "precision": 3,
                        "scale": 0,
                        "isNullable": 1
                    }
                ],
                "items": [
                    {
                        "COLUMN_NAME": "FILE_VERSION",
                        "INSERTABLE": "YES",
                        "UPDATABLE": "YES"
                    },
                    {
                        "COLUMN_NAME": "MODULE",
                        "INSERTABLE": "YES",
                        "UPDATABLE": "YES"
                    },
                    {
                        "COLUMN_NAME": "FILENAME",
                        "INSERTABLE": "YES",
                        "UPDATABLE": "YES"
                    },
                    {
                        "COLUMN_NAME": "CONTENT",
                        "INSERTABLE": "YES",
                        "UPDATABLE": "YES"
                    },
                    {
                        "COLUMN_NAME": "MIMETYPE",
                        "INSERTABLE": "YES",
                        "UPDATABLE": "YES"
                    },
                    {
                        "COLUMN_NAME": "MODIFIED",
                        "INSERTABLE": "YES",
                        "UPDATABLE": "YES"
                    }
                ],
                "limit": 100,
                "count": 6
            },
            "response": [
                
            ]
        }
    ]
}
[5/28/2024, 5:48:23 PM] [DBToolsServerApp(10812)] [DEBUG] - - - [28/May/2024:15:48:23 +0000] "POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1" 200 - "-" "-" 45
[5/28/2024, 5:48:23 PM] [DBToolsServerApp(10812)] [DEBUG] POST /20221610/databases/connections/sessions/llIEFGYncA6fgsmxzRQg0g/actions/execute HTTP/1.1
Host: localhost
Request-Id: 4bmdzm3oj-Vn97juOO8A2g
Accept: application/json
Authorization: Signature key***6tA=="
Content-Length: 330
Content-Type: application/json
x-content-sha256: hrm77Lun/iTuwBidTQIskwqpZSu7xVvj+QARlzj3d+0=
x-date: Tue, 28 May 2024 15:48:23 GMT
User-Agent: node-fetch/1.0 (+https://github.com/bitinn/node-fetch)
Accept-Encoding: gzip,deflate
Connection: close

{
    "statementText": "SELECT \"FILE_VERSION\", \"MODULE\", \"FILENAME\", \"CONTENT\", \"MIMETYPE\", \"MODIFIED\" ,ROWID AS \"ora_rowid\" FROM (\"APEX_USER\".\"STATIC_FILES\")  ",
    "binds": [
        {
            "name": "OBJECT_OWNER",
            "value": "APEX_USER",
            "dataType": "VARCHAR2"
        },
        {
            "name": "OBJECT_NAME",
            "value": "STATIC_FILES",
            "dataType": "VARCHAR2"
        }
    ],
    "fetchSize": -1,
    "limit": 100,
    "lineSize": 32767,
    "historyMode": "IGNORE"
}
[5/28/2024, 5:48:30 PM] [DBToolsServerApp(10812)] [DEBUG] HTTP/1.1 200 OK
Content-Type: application/json
Request-Id: 4bmdzm3oj-Vn97juOO8A2g
Link: <http://localhost:65416/20221610/tasks/dOtLNYMWgRogVP_BwAlxCw/> ; rel="dbtools:rel:task"

{
    "env": {
        "defaultTimeZone": "Z"
    },
    "items": [
        {
            "statementId": 1,
            "statementType": "query",
            "statementPos": {
                "startLine": 0,
                "endLine": 1
            },
            "statementText": "SELECT \"FILE_VERSION\", \"MODULE\", \"FILENAME\", \"CONTENT\", \"MIMETYPE\", \"MODIFIED\" ,ROWID AS \"ora_rowid\" FROM (\"APEX_USER\".\"STATIC_FILES\")",
            "resultSet": {
                "metadata": [
                    {
                        "columnName": "FILE_VERSION",
                        "columnTypeName": "VARCHAR2",
                        "precision": 128,
                        "scale": 0,
                        "isNullable": 1
                    },
                    {
                        "columnName": "MODULE",
                        "columnTypeName": "VARCHAR2",
                        "precision": 255,
                        "scale": 0,
                        "isNullable": 0
                    },
                    {
                        "columnName": "FILENAME",
                        "columnTypeName": "VARCHAR2",
                        "precision": 255,
                        "scale": 0,
                        "isNullable": 0
                    },
                    {
                        "columnName": "CONTENT",
                        "columnTypeName": "BLOB",
                        "isNullable": 1
                    },
                    {
                        "columnName": "MIMETYPE",
                        "columnTypeName": "VARCHAR2",
                        "precision": 80,
                        "scale": 0,
                        "isNullable": 1
                    },
                    {
                        "columnName": "MODIFIED",
                        "columnTypeName": "DATE",
                        "precision": 0,
                        "scale": 0,
                        "isNullable": 1
                    },
                    {
                        "columnName": "ora_rowid",
                        "columnTypeName": "ROWID",
                        "precision": 0,
                        "scale": 0,
                        "isNullable": 0
                    }
                ],
                "items": [
                    {
                        "FILE_VERSION": null,
                        "MODULE": "apex-112",
                        "FILENAME": "ol.js",
                        "CONTENT": "Ly8g[....]",
                        "MIMETYPE": "text/javascript",
                        "MODIFIED": "2019-06-28T00:00",
                        "ora_rowid": "AAAVzrAAAAAAAObAAA"
                    }]}