This discussion is archived
5 Replies Latest reply: Dec 13, 2012 12:46 AM by BluShadow RSS

Escaping & in select list

947771 Newbie
Currently Being Moderated
Hi

In select list i am making link like
select <a target="_blank" href="pageurl?Id=' || CAST(a.id AS VARCHAR2(30)) || '&xid=3' ||  '">' || CAST(a.id AS VARCHAR2(30))  || '</a>'

from t a
this prompt for input but in SP it does not

i found some solution please suggest me which one i should use.

1)SET DEFINE OFF;
or

2)SET ESCAPE ON;
SELECT 'blah \& blah' AS DES FROM DUAL;

or

3)select 'blah&' || 'blah' from dual;

yours sincerely

Edited by: BluShadow on 11-Dec-2012 13:48
added code tags to the original code to make it readable. Please read {message:id=9360002} and learn to do this yourself.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points