Oracle number conversion.

Post Reply
gaurav.shetti
Posts: 119
Joined: Fri Feb 27, 2009 9:09 am

Oracle number conversion.

Post by gaurav.shetti »

I have been using a simple query to extract ids of persons from oracle. One of the id in oracle table which was 1369197 was returned as 1.3692e+06. I dont want such conversion to take place. Morever the column in which i am storing this data is a varchar column which stores ids in comma separated string like ( 12345, 32432543, 234234)

Please guide.
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Oracle number conversion.

Post by mark »

What's the query? What's the type of the oracle field?
Maybe you should convert it to varchar when extracting?
Post Reply