Technical Blog

To get decimals points and vicevers SELECT REGEXP_REPLACE('18.01', '(\d+)\.(\d+)', '\1') FROM dual; SELECT REGE...

ORA-00932: inconsistent datatypes: expected - got CLOB WHY THIS ERROR OCCURRING ? WHEN WE EXECUTE THIS QUERY IT RESULTS TO AN ERROR (IE :...

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