Here, You can use TOAD utility. Heat the query... After result is popul

How to export the table data (this table having 18 million
records) to .csv file. Please tell me is there any faster
way to export the data.

Question Posted / piyush shobhane

8 Answers
34278 Views
I also Faced
E-Mail Answers

Answer Posted / piyush shobhane

Here, You can use TOAD utility.
Heat the query...

After result is populated in tables below make save as
Option: EXCEL FILE
Format: CSV file

It will automatically starts saving files upto the last
record. Get Toad and u will done...

Piyush

Is This Answer Correct ?

13 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you write a subquery?

1002

What is sql*plus?

1054

Why do we need sharding?

975

How can we debug in PL/SQL?

1118

Is left join same as join?

971

What are all the different normalizations?

1020

What is sql profiler in oracle?

1068

How to display the current date in sql?

1052

What are the three pl sql block types?

983

how to drop an existing index in mysql? : Sql dba

1052

What is the difference between sql and mysql?

1099

how tsql statements can be written and submitted to the database engine? : Transact sql

963

Is sql harder than python?

1076

Why are cursors used?

1102

How to place comments in pl/sql?

1139