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 / aryasen vaikom

Hi Kiran,
pls go through the below link.
http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are commit, rollback, and savepoint?

740


What is sql clause?

741


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

816


What are the advantages of pl sql?

835


Is pl sql different from sql?

719






how does a local variable is defined using t-sql? : Transact sql

735


What is the use of count (*) in sql?

754


What is %s in sql?

755


What is a call statement? Explain with an example.

747


What is sql constant?

677


Is join an inner join?

721


What is over () in sql?

688


what is online transaction processing (oltp)? : Sql dba

713


What is the best free sql database?

771


write an sql query to find names of employee start with 'a'? : Sql dba

779