Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2012

    Lightbulb Unanswered: Question regarding regexp_replace

    I am running below queries:-
    SQL> select regexp_replace('AB,CD','(..),',q'['\1',]') from dual;
    SQL>select regexp_replace('AB,CD,DE','(..),',q'['\1',]') from dual;
    But in both cases the single quote is missing in the last pair, can somebody help me fix the regex and replacement rules?

    EDIT: Never mind, got the solution.
    Last edited by Voltage; 12-05-12 at 01:29.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts