SQL & PL/SQL

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.