this prompt for input but in SP it does not
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
944768 wrote:Me personally, I wouldn't use either of those, I'd use "set define off" when submitting my code for compilation through SQL*Plus, or use the appropriate equivalent setting through TOAD or whatever tool I'm using (they each have their own way to ignore substitution variables)
i am planning to use this hevealy
which one i should use.
select '&'||'xid=3' from dual;
CHR (38) in place of '&'.