Technical Blog

Contains alphabets SELECT * FROM test WHERE REGEXP_LIKE(testcol, '[[:alpha:]]') Contains only alphabets SELECT * FROM test W...

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'); ---------------------...