Re: Reserved Characters in Varchar Variable

danielroy10_at_hotmail.com (Daniel Roy) wrote in message news:<1b061893.0212041504.78f404de_at_posting.google.com>...
> I have this SQL*Plus report with a query which compares varchar2
> variables from 2 tables in the where clause. These variables don't
> seem to work when they contain special characters like "/", "-" or
> spaces. What should I do so that SQL*Plus just takes these characters
> literally, without "interpreting" them? I run on 8.1.6.
>
> Thank you
>
> Daniel

Enclose all identifiers in ""
You don't *WANT* to use special characters, they will develop into a nail in your coffin.

Sybrand Bakker
Senior Oracle DBA Received on Thu Dec 05 2002 - 10:19:35 CET