Technical Blog

Find the position of try, trying, tried or tries SELECT REGEXP_INSTR('We are trying to make the subject easier','tr(y(ing)?|(...

REGEXP_LIKE SELECT * FROM scott.emp WHERE REGEXP_LIKE(ENAME,'FR') ; OR SELECT * FROM scott.emp WHERE ENAME LIKE '%FR%'...

Usually after a DML statement to make the change permenantly in the database we should execute commit statement . Example update scott.e...

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