Re: Changing the text delimiter (')

If you need to use single quote as part of a string, try this:

select '''single quote'' test' from dual;

Alexandre Leite
leite_alexandre_at_hotmail.com Received on Fri Mar 26 1999 - 07:52:40 CST