| NAME_COL_PLUS_SHOW_PARAM | TYPE | VALUE_COL_PLUS_SHOW_PARAM |
|---|---|---|
| fixed_date | string |
SQL> SELECT NAME ,
2 PLATFORM_NAME ,
3 DATABASE_ROLE
4 FROM v$database ;
| NAME | PLATFORM_NAME | DATABASE_ROLE |
|---|---|---|
| TTN020 | Linux x86 64-bit | PRIMARY |
1 row selected.
SQL>
SQL>
SQL> SELECT
2 ( SELECT startup_time FROM v$instance ) startup_time ,
3 ( SELECT SYSDATE FROM DUAL ) captured_time
4 FROM DUAL ;
| STARTUP_TIME | CAPTURED_TIME |
|---|---|
| 15/05/2019 08:09:26 | 17/05/2019 14:04:26 |
1 row selected.
SQL>
SQL>
SQL> SELECT *
2 FROM V$version
3 WHERE banner LIKE 'Oracle Database%' ;
| BANNER | CON_ID |
|---|---|
| Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production | 0 |
1 row selected.
SQL>
SQL> SELECT SESSIONTIMEZONE, DBTIMEZONE FROM DUAL;
| SESSIONTIMEZONE | DBTIME |
|---|---|
| GMT | +01:00 |
1 row selected.
SQL> show user
USER is "SYS"
SQL> Select CAST(to_timestamp_tz(replace('2018-04-11T23:21:05-02:00','000'), 'yyyy-mm-dd"T"hh24:mi:ss TZH:TZM') at time zone DBTIMEZONE AS DATE) from dual;
| CAST(TO_TIMESTAMP_T |
|---|
| 11/04/2018 22:21:05 |
1 row selected.
SQL> select to_char(systimestamp, 'DD/MM/YYYY HH24:MI:SS TZR') from dual;
| TO_CHAR(SYSTIMESTAMP,'DD/MM/YYYYHH24:MI:SSTZR') |
|---|
| 17/05/2019 14:04:26 +00:00 |
1 row selected.
SQL> select to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS') from dual;
| TO_CHAR(SYSDATE,'DD |
|---|
| 17/05/2019 14:04:26 |
1 row selected.
SQL> SET SPACE 1 LINESIZE 80 PAGES 1000
SQL> SELECT * FROM (
2 select to_char(ORIGINATING_TIMESTAMP,'YYYY/MM/DD HH24:MI:SS TZH:TZM')
3 from V$DIAG_ALERT_EXT
4 WHERE trim(COMPONENT_ID)='rdbms'
5 and MESSAGE_TEXT like ('PMON started with%')
6 order by originating_timestamp desc )
7 WHERE rownum < 20;
| TO_CHAR(ORIGINATING_TIMEST |
|---|
| 2019/05/15 08:09:30 +00:00 |
| 2019/05/09 15:08:09 +00:00 |
| 2019/04/21 17:20:42 +00:00 |
| 2019/04/21 17:18:47 +00:00 |
4 rows selected.
SQL> ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT ='DD/MON/YYYY HH24:MI:SS TZR TZD';
Session altered.
SQL> ALTER SESSION SET NLS_TIMESTAMP_FORMAT ='DD*MON*YYYY HH24:MI:SS';
Session altered.
SQL> ALTER SESSION SET NLS_DATE_FORMAT ='DD-MON-YYYY HH24:MI:SS';
Session altered.
SQL> select SESSIONTIMEZONE, CURRENT_DATE, CURRENT_TIMESTAMP, LOCALTIMESTAMP ,SYSDATE, SYSTIMESTAMP from dual;
| SESSIONTIMEZONE | CURRENT_DATE | CURRENT_TIMESTAMP | LOCALTIMESTAMP | SYSDATE | SYSTIMESTAMP |
|---|---|---|---|---|---|
| GMT | 17-MAY-2019 14:05:06 | 17/MAY/2019 14:05:06 GMT GMT | 17*MAY*2019 14:05:06 | 17-MAY-2019 14:05:06 | 17/MAY/2019 14:05:06 +00:00 |
1 row selected.
SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%'ORDER BY PROPERTY_NAME;
| PROPERTY_NAME | VALUE |
|---|---|
| DST_PRIMARY_TT_VERSION | 18 |
| DST_SECONDARY_TT_VERSION | 0 |
| DST_UPGRADE_STATE | NONE |
3 rows selected.
SQL> select * from v$timezone_file;
| FILENAME | VERSION | CON_ID |
|---|---|---|
| timezlrg_18.dat | 18 | 0 |
1 row selected.
SQL> select c.owner || '.' || c.table_name || '(' || c.column_name || ') -' || c.data_type || ' ' col from dba_tab_cols c, dba_objects o where c.data_type like '%WITH TIME ZONE' and c.owner=o.owner and c.owner not in ('SYS','WMSYS','DBSNMP','SYSMAN') and c.table_name = o.object_name and o.object_type = 'TABLE' order by col;
| COL |
|---|
| APEX_040100.WWV_FLOW_DEBUG_MESSAGES(MESSAGE_TIMESTAMP) -TIMESTAMP(6) WITH TIME Z ONE |
| APEX_040100.WWV_FLOW_DEBUG_MESSAGES2(MESSAGE_TIMESTAMP) -TIMESTAMP(6) WITH TIME ZONE |
| APEX_040100.WWV_FLOW_FEEDBACK(CREATED_ON) -TIMESTAMP(6) WITH TIME ZONE |
| APEX_040100.WWV_FLOW_FEEDBACK(UPDATED_ON) -TIMESTAMP(6) WITH TIME ZONE |
| APEX_040100.WWV_FLOW_FEEDBACK_FOLLOWUP(CREATED_ON) -TIMESTAMP(6) WITH TIME ZONE |
| APEX_040100.WWV_FLOW_FEEDBACK_FOLLOWUP(UPDATED_ON) -TIMESTAMP(6) WITH TIME ZONE |
| APEX_040100.WWV_FLOW_WORKSHEET_NOTIFY(OFFSET_DATE) -TIMESTAMP(6) WITH TIME ZONE |
| AQ_MONITOR.AQMON_BQUEUES_TAB(LAST_DEQUEUE_TIME) -TIMESTAMP(3) WITH TIME ZONE |
| AQ_MONITOR.AQMON_BQUEUES_TAB(LAST_ENQUEUE_TIME) -TIMESTAMP(3) WITH TIME ZONE |
| AQ_MONITOR.AQMON_BSUBSCRIBERS_TAB(LAST_DEQUEUE_TIME) -TIMESTAMP(3) WITH TIME ZON E |
| AQ_MONITOR.AQMON_PQMNCACHE_TAB(LAST_DEQLOG_PROCESSING_TIME) -TIMESTAMP(3) WITH T IME ZONE |
| AQ_MONITOR.AQMON_PQMNCACHE_TAB(LAST_INDEX_CLEANUP_TIME) -TIMESTAMP(3) WITH TIME ZONE |
| AQ_MONITOR.AQMON_PQMNCACHE_TAB(LAST_TMGR_PROCESSING_TIME) -TIMESTAMP(3) WITH TIM E ZONE |
| AQ_MONITOR.AQMON_PQMNCACHE_TAB(NEXT_SERVICE_TIME) -TIMESTAMP(3) WITH TIME ZONE |
| AQ_MONITOR.AQMON_PQMNCACHE_TAB(WINDOW_END_TIME) -TIMESTAMP(3) WITH TIME ZONE |
| AQ_MONITOR.AQMON_SUBREG_TAB(LAST_ERR_TIME) -TIMESTAMP(3) WITH TIME ZONE |
| AQ_MONITOR.AQMON_SUBREG_TAB(LAST_NTFN_SENT_TIME) -TIMESTAMP(3) WITH TIME ZONE |
| AQ_MONITOR.AQMON_SUBREG_TAB(LAST_NTFN_START_TIME) -TIMESTAMP(3) WITH TIME ZONE |
| AQ_MONITOR.AQMON_SUBREG_TAB(LAST_UPDATE_TIME) -TIMESTAMP(3) WITH TIME ZONE |
| DVSYS.AUDIT_TRAIL$(EXTENDED_TIMESTAMP) -TIMESTAMP(6) WITH TIME ZONE |
| GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_REF_OWNER.AQ$_REFERENCEDATANEW_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_REF_OWNER.AQ$_REFERENCEDATANEW_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_REF_OWNER.AQ$_REFERENCEDATANEW_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_REF_OWNER.AQ$_REFERENCEDATANEW_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_ASSAY_EVENT_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_ASSAY_EVENT_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_ASSAY_EVENT_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_ASSAY_EVENT_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_ASSAY_INTERNAL_EVENT_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_ASSAY_INTERNAL_EVENT_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_ASSAY_INTERNAL_EVENT_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_ASSAY_INTERNAL_EVENT_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_CNI_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_CNI_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_CNI_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_CNI_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_LOGISTICS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_LOGISTICS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_A_LOGISTICS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_A_LOGISTICS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_LOGISTICS_VERSIONS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_LOGISTICS_VERSIONS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_LOGISTICS_VERSIONS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_LOGISTICS_VERSIONS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_REFERENCEDATANEW_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_REFERENCEDATANEW_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_REFERENCEDATANEW_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_REFERENCEDATANEW_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WI TH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_STARLING_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_STARLING_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_STARLING_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_STARLING_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_STUB_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_STUB_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_STUB_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_STUB_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_TRADESERVICE_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_A_TRADESERVICE_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_TRADESERVICE_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_A_TRADESERVICE_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_BDC_EVENT_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_BDC_EVENT_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_BDC_EVENT_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_BDC_EVENT_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_CNI_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_CNI_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_CNI_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_CNI_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_CS_FINANCE_EVENTS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIM E ZONE |
| TRAF_TITAN_OWNER.AQ$_CS_FINANCE_EVENTS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_CS_FINANCE_EVENTS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_CS_FINANCE_EVENTS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WIT H TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_CS_TO_MUREX_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_CS_TO_MUREX_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_CS_TO_MUREX_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_CS_TO_MUREX_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_EODS_EVENT_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_EODS_EVENT_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_EODS_EVENT_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_EODS_EVENT_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_FIN_EVENTS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_FIN_EVENTS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_FIN_EVENTS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_FIN_EVENTS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_HM_TO_MUREX_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_HM_TO_MUREX_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_HM_TO_MUREX_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_HM_TO_MUREX_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_PRIVATE_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIM E ZONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_PRIVATE_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_PRIVATE_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_PRIVATE_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WIT H TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_SEC_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZO NE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_SEC_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_SEC_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_INVOICING_SEC_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_INV_MGMT_EVENT_BUS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_INV_MGMT_EVENT_BUS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_INV_MGMT_EVENT_BUS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_INV_MGMT_EVENT_BUS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WI TH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_INV_TO_PM_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_INV_TO_PM_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_INV_TO_PM_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_INV_TO_PM_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_LOGISTICS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_LOGISTICS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_LOGISTICS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_LOGISTICS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_LOG_INTERNAL_EVENT_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_LOG_INTERNAL_EVENT_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_LOG_INTERNAL_EVENT_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_LOG_INTERNAL_EVENT_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WI TH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_CS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_CS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_CS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_CS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_HM_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_HM_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_HM_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_HM_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_OM_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_OM_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_OM_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_MUREX_TO_OM_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_OM_TO_HM_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_OM_TO_HM_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_OM_TO_HM_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_OM_TO_HM_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZO NE |
| TRAF_TITAN_OWNER.AQ$_OM_TO_MUREX_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_OM_TO_MUREX_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_OM_TO_MUREX_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_OM_TO_MUREX_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_OM_UI_EVENTS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZON E |
| TRAF_TITAN_OWNER.AQ$_OM_UI_EVENTS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZO NE |
| TRAF_TITAN_OWNER.AQ$_OM_UI_EVENTS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZO NE |
| TRAF_TITAN_OWNER.AQ$_OM_UI_EVENTS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIM E ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_CNI_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_CNI_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_CNI_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_CNI_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_INV_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_INV_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_INV_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_INV_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_LOG_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_LOG_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_LOG_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_LOG_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_TVE_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_TVE_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_TVE_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_TVE_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_UI_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_UI_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_UI_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PM_TO_UI_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZO NE |
| TRAF_TITAN_OWNER.AQ$_PNL_TO_TVE_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PNL_TO_TVE_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PNL_TO_TVE_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PNL_TO_TVE_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PNL_TO_UI_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PNL_TO_UI_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PNL_TO_UI_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PNL_TO_UI_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_PRICE_MGMT_EVENT_BUS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PRICE_MGMT_EVENT_BUS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PRICE_MGMT_EVENT_BUS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PRICE_MGMT_EVENT_BUS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_PRICE_MGMT_TVE_BUS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_PRICE_MGMT_TVE_BUS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_PRICE_MGMT_TVE_BUS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_PRICE_MGMT_TVE_BUS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WI TH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_QV_NA_DERIV_VALUATION_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_QV_NA_DERIV_VALUATION_QT_S(CREATION_TIME) -TIMESTAMP(6) WIT H TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_QV_NA_DERIV_VALUATION_QT_S(DELETION_TIME) -TIMESTAMP(6) WIT H TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_QV_NA_DERIV_VALUATION_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_QV_QA_DERIV_VALUATION_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_QV_QA_DERIV_VALUATION_QT_S(CREATION_TIME) -TIMESTAMP(6) WIT H TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_QV_QA_DERIV_VALUATION_QT_S(DELETION_TIME) -TIMESTAMP(6) WIT H TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_QV_QA_DERIV_VALUATION_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_QV_VALUATIONS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZO NE |
| TRAF_TITAN_OWNER.AQ$_QV_VALUATIONS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_QV_VALUATIONS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_QV_VALUATIONS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_SEC_EVENT_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_SEC_EVENT_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_SEC_EVENT_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_SEC_EVENT_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_TASK_STATE_SNAPSHOT_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_TASK_STATE_SNAPSHOT_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TASK_STATE_SNAPSHOT_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TASK_STATE_SNAPSHOT_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) W ITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TPS_IN_EVENTS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZO NE |
| TRAF_TITAN_OWNER.AQ$_TPS_IN_EVENTS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_TPS_IN_EVENTS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_TPS_IN_EVENTS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TI ME ZONE |
| TRAF_TITAN_OWNER.AQ$_TPS_OUT_EVENTS_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
| TRAF_TITAN_OWNER.AQ$_TPS_OUT_EVENTS_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TPS_OUT_EVENTS_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TPS_OUT_EVENTS_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH T IME ZONE |
| TRAF_TITAN_OWNER.AQ$_TRADE_MGMT_TT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TRADE_MGMT_TT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TRADE_MGMT_TT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TRADE_MGMT_TT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TVE_TO_PM_QT_L(DEQUEUE_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TVE_TO_PM_QT_S(CREATION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TVE_TO_PM_QT_S(DELETION_TIME) -TIMESTAMP(6) WITH TIME ZONE |
| TRAF_TITAN_OWNER.AQ$_TVE_TO_PM_QT_S(MODIFICATION_TIME) -TIMESTAMP(6) WITH TIME Z ONE |
216 rows selected.
SQL> select c.owner || '.' || c.table_name || '(' || c.column_name || ') -' || c.data_type || ' ' col from dba_tab_cols c, dba_objects o where c.data_type like '%WITH LOCAL TIME ZONE' and c.owner=o.owner and c.table_name = o.object_name and o.object_type = 'TABLE' order by col;
| COL |
|---|
| APEX_040100.APEX$ARCHIVE_CONTENTS(CONTENT_LAST_UPDATED) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
| APEX_040100.APEX$ARCHIVE_CONTENTS(CREATED) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
| APEX_040100.APEX$ARCHIVE_CONTENTS(UPDATED) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
| APEX_040100.APEX$ARCHIVE_HEADER(CREATED) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
| APEX_040100.APEX$ARCHIVE_HEADER(UPDATED) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
| APEX_040100.APEX$ARCHIVE_HISTORY(CREATED) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
| APEX_040100.APEX$ARCHIVE_LOG(CREATED) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
| APEX_040100.APEX$ARCHIVE_LOG(UPDATED) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
| APEX_040100.APEX$ARCHIVE_PREF(CREATED) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
| APEX_040100.APEX$ARCHIVE_PREF(UPDATED) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
| APEX_040100.WWV_FLOW_WORKSHEET_NOTIFY(END_DATE) -TIMESTAMP(6) WITH LOCAL TIME ZO NE |
| APEX_040100.WWV_FLOW_WORKSHEET_NOTIFY(START_DATE) -TIMESTAMP(6) WITH LOCAL TIME ZONE |
12 rows selected.
SQL> SELECT * FROM sys.dst$error_table;
no rows selected
SQL> SELECT * FROM sys.dst$affected_tables;
no rows selected
SQL>
SQL>
SQL> set markup html off
SQL> spool off