tz_offset in Oracle

select tz_offset('Asia/Singapore') from dual;