The string has worked well for me over time - one other comment, don't forget that CSV may need to "escape" an embedded delimiter - for example, if one's alphanumeric field contains a comma (e.g. the field separator), one now needs to enclose the field with a text delimiter such as...
This is the same class of problem as when using the IN predicate and not knowing how many host variables to place within the parentheses. There are two options:
1. Build the SQL as IN (:1, :2, :3, :4, :5 ... :N) where N is the reasonable maximum. When the number of values is less than N...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.