How to handle ' , ' in the data of csv file

Hey...if any of the fields in sql loader script.. eg.. empname is Jain,anisha then how can we handle this ' , ' in Jain,anisha while using csv file in a sql loader

Questions by anishajain

Showing Answers 1 - 2 of 2 Answers

siddhshah

  • Jun 22nd, 2009
 

One needs to enter the value with double quotes like "Jain, Anisha" to all the values so the comma can be stored in the columns.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.