Re: Fooling Oracle with &

From: Rudi Demeulenaere <rdm_at_mentor.spamnothanks.be>
Date: Thu, 30 Apr 1998 20:22:07 +0200
Message-ID: <3548C14F.A5DEEA08@mentor.spamnothanks.be>

NEWSOL97 wrote:

> Hi all,
>
> This is probably an ancient topic but does anyone know how to express an
> & in a character string without the SQL parser trying to tokenize it? In other
> words if I had
> "Sally & Bob"

What about "Sally " || chr(38) || " Bob"

r u d i
(remove anti-spam measure from reply-address) Received on Thu Apr 30 1998 - 13:22:07 CDT

This message: [ Message body ]
Next message: Rudi Demeulenaere: "Re: Selecting records by the Time of a Date column"
Previous message: Rudi Demeulenaere: "Re: Dynamic SQL in PL/SQL"
In reply to: NEWSOL97: "Fooling Oracle with &"
Next in thread: Joel Garry: "Re: Fooling Oracle with &"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US