Technical Blog

Try to avoid using  following in triggers 1) UTL_ packages .  They do not roll back 2) Pragma autonomous_transaction only use if it is ...

Improving Performance of Dynamic SQL with Bind Variables When you code INSERT, UPDATE, DELETE, and SELECT statements directly in PL/SQL,...

  It is recommend to use NOT EXIST instead of NOT IN ; do you know/thought  why ?  ! . You dont see any differences here because the ...

The Below example shows the difference in execution plan when a composite index is created   SELECT d.ITEM_ID,d.ITEM_DESC,D.UNIT,d.ITEM_...

A benchmark is the act of running a computer program, a set of programs, or other operations, in order to assess the relative performance of...

DECLARE my_task_name VARCHAR2(30); my_sqltext CLOB; BEGIN my_sqltext := 'select golflink,course_name,x,y from (select b.golflink,b...