Technical Blog

Trigger to detect SQL Injection Attacks   Problem with Trigger

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...