Technical Blog

Overlap If any of the condition in where clause of a query overlaps , with the parameter in overlap function query returns value else not...

CREATE OR REPLACE FUNCTION fnc_encryption(pi_src IN VARCHAR2) RETURN CLOB IS v_enc_val raw(32767); v_key1 VARCHAR2(16) := '1111111...

select DBMS_UTILITY.GET_TIME from dual; select * from v$timer; ---------------------------------------- Avoid duplicate To avoid duplicate r...

To get the higher manager of a particular employee select yy.empno,yy.mgr,yy.ename,rt.empno,rt.mgr,rt.ename from (select * from emp t conne...

1) www.orafaq.com/wiki/Main_Page 2) www.orafaq.com/wiki/Scripts 3) www.orafaq.com/wiki/SQL_FAQ