Technical Blog

Pinning stored procedure/function to shared pool in 11G execute dbms_shared_pool.keep(owner.trigger, 'R'); ---------------------...

ESCAPE With LIKE Operator select ename from scott.emp where ename like '%_%'; But you will be surprised to see the results: EN...

What is PRESENTATION=RO in tnsnames.ora file Check the entry in tnsnames.ora file: EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_L...

Which will run much slower than the other two, and why? a. DECLARE CURSOR employees_cur IS SELECT * FROM employees; BEGIN FOR employe...

Tuning the LIKE-clause (by using reverse key indexes) For tuning Like operator (like '%SON') is to create a REVERSE index - and th...