Re: Special Characters in SQLPlus?

In article <19990426211724.08426.00001949_at_ng94.aol.com>,   danhw_at_aol.com (DanHW) wrote:
> In a SQL select, whenever you need the escape, use CHR(27) [doublecheck on
> that - it might be CHAR]. This Oracle character function returns the character
> with the requested ASCII value.

Thanks for your response. The above did work for me, although the COLUMN command gave me trouble (and, strangely, my online SQL*Plus documentation from Oracle is missing chapter 4, which may contain the details on the COLUMN command. Just my luck. :-)

Anyway, that will work for me for now, although I will probably end up writing a front end program for others to put data in my tables, as they will quickly tire of concating CHR(xx) into the VARCHAR2 columns 100 or so times per row.

Thanks again for the idea ...

Brett

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 29 1999 - 19:35:41 CEST