5 Replies Latest reply: Dec 13, 2012 2:46 AM by BluShadow RSS

    Escaping & in select list

    947771
      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.