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

Why is sql important?

1098


how to enter characters as hex numbers? : Sql dba

1033


How to use transactions efficiently : transact sql

1050


What is the most restrictive isolation level? : Transact sql

1077


Is it possible to create startup or shutdown trigger for on-schema?

1019


What is fmtonly in sql?

1077


What are the advantages of pl sql?

1119


Is it important to partition hard disk?

1022


Explain the difference between sql and mysql.

1057


What are the types of join in sql?

1092


Why do we use subquery?

1004


What is %rowtype in pl sql?

985


What is the difference between the conventional and direct path loader? : aql loader

1149


What are functions in sql?

950


What is data manipulation language?

1183