asked on Sql/oracle query to handle comma and double quotes
Hi
I like to extract records from oracle db, by writing a awl query .
The query should check if a column has comma then put content of that column in a double quote else do not put it in double quote. This will be extracted to a comma delemited file, so all columns are separated by comma:
E.g:
A, gggg , "John , Silverado" , 12345
Thanks in advanced
I like to extract records from oracle db, by writing a awl query .
The query should check if a column has comma then put content of that column in a double quote else do not put it in double quote. This will be extracted to a comma delemited file, so all columns are separated by comma:
E.g:
A, gggg , "John , Silverado" , 12345
Thanks in advanced
Microsoft SQL ServerOracle Database
Last Comment
Sh M
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
There is a slight difference. In sql server, the search is the first parameter and the field is the second.
Oracle -
where instr(field,',') > 0
SQL Server
where charindex(',', field) > 0
Oracle -
where instr(field,',') > 0
SQL Server
where charindex(',', field) > 0
awking00 is correct, and I edited my first comment to reflect this catch. Thank you.
Another option for you is if you're using this in an ETL application such as SSIS, there is the ability within SSIS to use string delimiters such as double-quote marks to make sure a comma in those columns doesn't result in an error when the downstream process consumes the file.
shmz, do you still need help with this question?
ASKER
Thank you
change CHARINDEX to INSTR and "+" to "||":
Open in new window