Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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.

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

Which is faster view or stored procedure?

1009


how do you know if your mysql server is alive? : Sql dba

1127


Can pl sql procedure have a return statement?

1072


How to create a menu in sqlplus or pl/sql?

1167


how to enter numeric values as hex numbers? : Sql dba

1100


What is the location of pre_defined_functions.

1208


Which command is used to delete a package?

1234


Why do we use triggers?

1015


What is sap sql anywhere?

1163


Which kind of parameters cannot have a default value in pl sql?

1210


How do I view tables in sql developer?

1009


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1183


How many sql are there?

1050


Is nosql relational?

999


explain what is mysql? : Sql dba

1131