Create or replace type TIMEZONE_DIFF_type as object
(
DB_INSTANCE            VARCHAR2(10),
STARTUP_TIME                   VARCHAR2(20),
DATABASE_DEFAULT_TIME          TIMESTAMP(6),
SERVER_TZ                      VARCHAR2(20),
RPT_SERVER_TIME                VARCHAR2(45),
SESSION_TZ                     VARCHAR2(20),
DBZONE                         VARCHAR2(20),
TIMEZONE_DATE          TIMESTAMP(6),
COLLECTION_DATE                DATE
)

CREATE OR REPLACE TYPE TIMEZONE_DIFF_type_details IS TABLE OF TIMEZONE_DIFF_type

create table TIMEZONE_DIFF_1
(
 projects TIMEZONE_DIFF_type_details
)
nested table projects store as projects_nt;

select instance_name,startup_time, database_default_time,server_tz,rpt_server_time, session_tz,dbtime_zone,server_current_date,timezone_date
    from    (

    SELECT  a.inst_id,
    upper(b.instance_name) instance_name,
    to_char(b.startup_time, 'YYYY-MM-DD HH24:MI') startup_time,
    SYSTIMESTAMP database_default_time,
    substr(to_char(SYSTIMESTAMP), 30) server_tz,
    CURRENT_TIMESTAMP rpt_server_time,
    substr(to_char(CURRENT_TIMESTAMP), 30) session_tz,
    dbtimezone dbtime_zone,
    to_date(to_char(max(sample_time),'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') server_current_date,
    SYSTIMESTAMP AT TIME ZONE 'UTC' timezone_date
    FROM    gv$active_session_history@XYZ a, gv$instance@XYZ b
    WHERE   a.inst_id = b.inst_id
    group by a.inst_id,
    upper(b.instance_name),
    to_char(b.startup_time, 'YYYY-MM-DD HH24:MI'),
    dbtimezone
        )