| |
GeekInterview.com > Interview Questions > Oracle Apps > Apps Technical
| Print | |
Question: how to handle ' , ' in the data of csv file
Answer: 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 |
| April 04, 2008 04:36:12 |
#1 |
| harishkrishnagowda |
Member Since: April 2008 Total Comments: 3 |
RE: how to handle ' , ' in the data of csv file
|
Its better to remove ',' for that column using replace commands
For eg
REPLACE(TRANSLATE(empname, ',{}[]%"?*~&<>$|/@''', ' '),' ') |
| |
Back To Question | |
