This content has been marked as final. Show 6 replies
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.table_name = o.object_name
and o.object_type = 'TABLE'
order by col
and also do check
SELECT TZ_OFFSET('US/Pacific') FROM DUAL;