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

Daniel, observe (8.1.7.4):

UT1> select * from marktest;

FLD1 FLD2 FLD3

---------- ---------- ---------
one                 1 04-DEC-02
two                 2 03-DEC-02
three               3 02-DEC-02
 /-one              4 01-DEC-02

UT1> select * from marktest2;

FLD1 FLD2 FLD3

---------- ---------- ---------
one                 1 04-DEC-02
two                 2 03-DEC-02
three               3 02-DEC-02
 /-one              4 01-DEC-02

UT1> select a.*
  2 from marktest a, marktest2 b
  3 where a.fld1 = b.fld1
  4 /

FLD1 FLD2 FLD3

---------- ---------- ---------
one                 1 04-DEC-02
two                 2 03-DEC-02
three               3 02-DEC-02
 /-one              4 01-DEC-02

I do not see you problem. You need to post something for people to look at! Also you should include your version platform information.

HTH -- Mark D Powell -- Received on Thu Dec 05 2002 - 15:59:54 CET