Re: [SQL] HOw to convert unicode to string

2012-10-01 Thread Jasen Betts
On 2012-09-23, Abhijit Prusty -X (abprusty - UST Global at Cisco) wrote: > --_000_8A2A33BFAA5E2F408D0BBB80844412720487D0xmbalnx03ciscocom_ > Content-Type: text/plain; charset="us-ascii" > Content-Transfer-Encoding: quoted-printable > > Hi, > > I have a query in oracle like this mentioned below >

[SQL] HOw to convert unicode to string

2012-09-24 Thread Abhijit Prusty -X (abprusty - UST Global at Cisco)
Hi, I have a query in oracle like this mentioned below Insert into TEST (TEMPLATE_ID, TEMPLATE_NAME, CREATED_BY, CREATED_DT, UPDATED_BY, UPDATED_DT, TEMPLATE_KEY) Values (1, UNISTR('\D3C9\BA85\B3C4 \B514\C2A4\D50C\B808\C774'), 'dmin', SYSDATE, 'admin', SYSDATE ,'FLOOR'); Now the o