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
- 32240 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
What is sql used for?
What are different sql data types?
What are joins in sql?
What is the usage of nvl function?
How many types of primary keys are there?
what are the advantages of using stored procedures? : Sql dba
How many types of functions are there in sql?
How to check if a column is nullable before setting to nullable?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Are views faster than queries?
Can we use insert statement in function?
What does pl sql stand for?
What are the different types of constraints?
What are different types of queries in sql?
What program will open a mdb file?
