For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
WITH t AS (SELECT 'my email is abc@yahoo.co.in' col1 FROM dual ) SELECT t.col1 , LTRIM(REGEXP_SUBSTR(t.col1, '@[^[:space:]]+'), '@') solution_1 , REGEXP_REPLACE(t.col1, '@([^[:space:]]+)|.', '\1') solution_2 FROM t ; OL1 SOLUTION_1 SOLUTION_2 -------------------------- --------------------------- -------------------- y email is abc@yahoo.co.in yahoo.co.in yahoo.co.in