Oracle Express Edition Export Results

[mikawin]

Hello,

I am using the web based Oracle Express Edition. When I am trying to save the results of my query, it exports it as .csv. Is it possible to change this?

The .csv format truncates to the results to 65,500 records and I have more than this in my result set.

Thanks,
Mika.

 

[oradba101]

Greetings,

Are you using Oracle Application Express as well?

Regards,


William Chadbourne
Programmer/Analyst

 

[KenCunningham]

Mika - are the 65,500 records a result of opening the file up in Excel? What about if it's opened up as a simple text file?

Oracle's free SQL Developer allows you to choose the delimiter used when saving the results of a query.

Some days are diamonds, some days are rocks - make sure most are the former.

 

[mikawin]

Hello William,

Yes I am using Oracle Application Express.

Thanks,
Mikawin

 

[mikawin]

Hello KenCunningham,

No, it does not work. I have tried opening with a notepad and couple of other text editiors, it still gives me only 65,000 records.

Thanks,
Mikawin