Technical Blog

To  retrieve only numeric values from both numeric& character value In 10 g Select  regexp_replace(regexp_replace('5RTYDDB',...

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

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

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