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 is left join in sql?

594


Are there any features that are decommissioned in 11g that are not present in 11g?

1611


How to read xml file in oracle pl sql?

521


How do I audit the sql sent to the server?

534


Why is a trigger used?

539






What is sp_helptext?

603


What is not in sql?

510


What is difference between rank () row_number () and dense_rank () in sql?

590


What is the use of stored procedures?

531


What are the different set operators available in sql?

572


What is clause?

618


What is difference between pl and sql?

543


which operator is used in query for pattern matching? : Sql dba

560


What is thread join () in threading?

552


Is sql better than excel?

526