CODEWITHSUNDEEP
oracle-databaseselect
xyz
xyz

Reputation: 2160

selecting huge data in oracle

I have to select data form a table under Oracle 10.The statement I have simply used is 

select * from table_name;

After the execution of the statement it first fetches 50 rows. Thenafter I just select ctrl+A to select all the rows and export it to a csv file. But it is taking a lot of time. Is there a better way to fetch all the rows and capture the data to csv?

Upvotes: 0

Views: 316

Answers (1)

user3012724
user3012724

Reputation: 85

You can use Oracle SQL Developer tool connect to database and right click on Table which is the table you want export the data then select Export option there you can select Format as CSV or After select * from table_name; go to result then right mouse click, then select Export then select Format as CSV and select the path where you want save then then Next then Finish

Upvotes: 1

Related Questions