Want to extract/export 1, 766, 048 records from oracle SQL developer tools

Question

1.00/5 (2 votes)

See more:

Hi All,

I Want to extract 1,766,048 records into any file extension like (.xls,.xlsx,.csv) from Oracle SQL Developer tools.

Is there any specific keywords which can be used with select query while extracting data like (Limit, range..! Any other techniques?) through which i can extract data in section wise.

Note: I'm using select statement to fetch data from multiple tables using Oracle SQL Developer tools.


Please suggest and guide me as soon as possible, i need all records and data is important.

What I have tried:

i've used limit keyword.
and not able to found any solutions.

Posted 23-Jun-17 1:43am

parthdoshi

Updated 23-Jun-17 4:55am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AnvilRanger · Answer 1 · 2017-06-23T04:55:00

Solution 1

Make sure you run your statement with the Run Statement option (Ctrl + Enter). Then in the query results grid click any cell and then press Ctrl + End and that will fetch all records.

To export just right click in the query results grid and select Export and one of the format options is Excel.

Posted 23-Jun-17 4:55am

AnvilRanger

Comments

parthdoshi 23-Jun-17 12:40pm

@AnvilRanger , Thank you! But this think i already tried and not able to get 1,766.048 records in one Excel file.

can you please guide me as soon as possible.

AnvilRanger 23-Jun-17 12:54pm

You can't. Excel has a max limit of just over 1 million rows.