how to cope with ampersand '&' in programming code
Hi all gurus
'&' is not creating problem when the following querry is run on TOAD and also gives result when i set define off in sql*plus .But create problems when we run in java programming codes . escape operator ' \ ' also not working on sql*plus.
plz suggest
Select * from (SELECT M.MAIL_ID, MAIL_FROM, M.SUBJECT AS S1, M.MAIL_SIZE AS MAIL_SIZE, TO_CHAR(MAIL_DATE,'dd Mon yyyy hh:mi:ss am') AS MAIL_DATE1, M.ATTACHMENT_FLAG, M.MAIL_TYPE_ID, M.PRIORITY_NO, M.TEXT, M.MAIL_STATUS_VALUE, 0 as email_address, M.MAIL_to as Mail_to, M.Cc, M.MAIL_DATE AS MAIL_DATE, subject as subject, read_ipaddress,read_datetime, Folder_Id,compose_type,interc_count,history_id,pined_flag,charset, rank() over( order by mail_date desc, m.mail_id desc) as rnk from v$mail M WHERE M.USER_ID=227 AND FOLDER_ID NOT IN (4, 5,6,7,8,21,22) and upper(decode64(subject)) LIKE '%&%' AND FOLDER_ID NOT IN ( 5,6,21,22)) where rnk between 1 and 10
thanks n regards
Message was edited by:
Cool_Jr.DBA
Message was edited by:
Cool_Jr.DBA