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.
- 8 Answers
- 32843 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
Describe different types of general function used in sql?
How can we find duplicate records in a table?
What are conditional predicates?
explain the delete statements in sql
What is minus?
How would you reference column values before and after you have inserted and deleted triggers?
What is the difference between left and left outer join?
What are the different types of functions in sql?
What is t sql used for?
How do I send sql query results to excel?
How can we avoid duplicating records in a query?
What is a table in a database?
Can we call a function containing dml statements in a select query?
Which join condition can be specified using on clause?
What will you get by the cursor attribute sql%found?
