0

I am exporting data from oracle table into a csv file. I have a column of varchar2 datatype and it has values like 1.1 and 1.10. When I export these to a csv file the value 1.10 becomes 1.1 and thus creating duplicate records. Is there a way to get both the values 1.10, 1.1 into csv file without loosing the last zero in "1.10".

I am using sqldeveloper and pl/sql developer and using excel to open the csv file. Ideally it should display the number as it is since its a varchar. But this is not happening. When I export it in xls/text format I am getting the correct result. But not with csv. But I want the file to be in csv format.

Improve this question
7
  • Oracle probably stores your (version?) data as text, but this information is lost when you export to csv and excel considers it to be number. I don't know how is possible to change settings at open, best way I think is to open your file in notepad or similar and copy the content to excel. There you'll have all the data in one column, separated by comma, go to data - "text to columns" and there you'll be able to specify your problematic column to be text
    – Máté Juhász
    Commented Aug 10, 2015 at 13:12
  • @Mate I tried exporting data to text then opened it in excel and specified the required column as text. But as soon as I save it as .csv it removes the last '0''s
    – sandywho
    Commented Aug 10, 2015 at 13:18
  • @sandywho Please read this answer
    – nixda
    Commented Aug 10, 2015 at 13:22
  • @nixda Thanks for the help. Itried everything but its not working. I think this is a bug in excel
    – sandywho
    Commented Aug 10, 2015 at 13:52
  • 1
    @sandywho I doubt that. Import your CSV with data import wizard as described in my link.This way, all values are stoed as text. Then, save it as CSV without changing anything in Excel. Open the CSV again, but with an editor like notepad. You will see that your zeros are still there. I just re-re-retested it
    – nixda
    Commented Aug 10, 2015 at 13:58

0

Reset to default

You must log in to answer this question.