Answer to "&" query
From: Mike Chan <mike.chan_at_bigfoot.com>
Date: 1997/09/19
Message-ID: <3422A808.1F9A_at_bigfoot.com>#1/1
Date: 1997/09/19
Message-ID: <3422A808.1F9A_at_bigfoot.com>#1/1
[Quoted] [Quoted] Below is the answer to those users which want "&" to be interpreted as it is instead of asking for a value.
in SQL*PLUS,
set escape /
select ..... where .... = 'A/&B';
Pls let me know if it works Received on Fri Sep 19 1997 - 00:00:00 CEST