Re: single quote in instr Oracle PL/SQL

From: Barbara Boehmer <baboehme_at_hotmail.com>
Date: 30 May 2005 14:23:53 -0700
Message-ID: <1117488233.739263.67660@f14g2000cwb.googlegroups.com>

Yes, I see your point now and agree that just using translate, instead of combining translate and replace, should be more efficient. So, the revised query would be something like:

scott_at_ORA92> SELECT TRANSLATE ('1234''~!@abcd',

  2                    'a~`!@#$%^&*()_+={}[]|\:;''",.<­>?',
  3                    'a')

  4 FROM DUAL
  5 /

TRANSLAT

---

1234abcd

1 row selected. Received on Mon May 30 2005 - 16:23:53 CDT