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
34413 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

What is the difference between sql and mysql?

1124

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1074

What are stuff and replace function?

1091

How do I know if I have sql express or standard?

1038

What is foreign key sql?

993

Explain the types of joins in sql?

1036

What do we need to check in database testing?

1026

Can we insert data into materialized view?

951

Is sql a backend?

1030

What is natural join in sql?

998

What is replication id?

941

Is pl sql different from sql?

1005

What is the most restrictive isolation level? : Transact sql

1087

Is primary key is clustered index?

1003

Is it important to partition hard disk?

1027