Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle Express Edition Export Results

Status
Not open for further replies.

mikawin

Technical User
Apr 15, 2009
28
US
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.
 
Greetings,

Are you using Oracle Application Express as well?

Regards,


William Chadbourne
Programmer/Analyst
 
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.
 
Hello William,

Yes I am using Oracle Application Express.

Thanks,
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top