Create a synonym in oracle database.
create or replace synonym my_schema_granted.my_db_object_synonym for schema_that_grants.db_object;
commit;

Get all days between two dates in oracle sql

select to_date('30-03-2017','dd-mm-yyyy') + rownum -1
from all_objects
where rownum <= to_date('30-04-2017','dd-mm-yyyy')-to_date('30-03-2017','dd-mm-yyyy')+1;

Split string in sql query – oracle

select regexp_substr('MyString,otherString,lastOneStr','[^,]+', 1, level) from dual
connect by regexp_substr('MyString,otherString,lastOneStr', '[^,]+', 1, level) is not null;

–Result :
———-
–MyString
–otherString
–lastOneStr

Simple way to enable a job in oracle scheduler.

BEGIN
DBMS_SCHEDULER.ENABLE (‘MY_AWESOME_JOB’);
END;
/

Split string in oracle sql query

select regexp_substr('MyString,otherString,lastOneStr','[^,]+', 1, 2) from dual; 
-- Returns 'otherString' String

Get TZH:TZM from TZR in oracle sql query

SELECT TZ_OFFSET('US/Pacific') FROM DUAL;