Re: HELP: SQL+ : How to use & in strings in PL/SQL scripts

[Quoted] << ... or use chr(38) in place of & in the source. (eg: instead of 'Ben & Jerry', code 'Ben ' || chr(38) || ' Jerry'.... >>

[Quoted] This should do just as well:


'Ben ' || '&' || ' Jerry'


[Quoted] At least it does under 7.3.4.


[Quoted] BTW, doyou know of a way where I can pass a DEFINEd string into the PL/SQL environment where that string could include single quotes? E.g.


define x = "&1"
declare xx varchar2(80);
begin

[Quoted]    xx := 'select whatever from table &x';

[Quoted] fails if &1 was something like "WHERE colname = 'value'" because of the quotes.

-- 
Oracle DBA / HPUX Sysadmin        | Rocky: "We're going to have 
Comalco Minerals & Alumina,       |  to think!"
Weipa, AUSTRALIA 4874             | Bullwinkle: "There must be
Tel 61-7-40698711 Fx.61-7-40698951|  an easier way than that."