Saturday, December 26, 2009

How to enter a single quotation mark in Oracle SQL Output?

SELECT S.IMSI||','||CHR(39)||s.SIM||CHR(39)||','||s.STATUS FROM SRC_ESN1 S

Will create output like

404909090123,'02320E34',A

No comments: