Hi,
Good Evening, I want to pull data in CSV format and I have written plsql procedure for that and I am able to export the data successfully but there is a concern that if a data contains a double quote then it's getting disappear in CSV export but I need that double to be there in data,
Please find the screenshot of plsql procedure for your refernce
For eg: i have entered data as "NAME" I need this in CSV format also
Can anyone please help me out?
Thanks in Advance
Ritch
Try this-- '"'||'RITESH'||'"'
SELECT '"'||'RITESH'||'"' FROM DUAL;
Swarup
Hi
if we use this then will get the static value whatever is present inside single quotes only that will reflect.
I need data from the oracle database if the user has entered in double-quotes then that double quotes also should come
Ritch
Dear check below..
SELECT '"'||ENAME||'"' FROM EMP;
"KING"
"BLAKE"
"CLARK"
"JONES"
"SCOTT"
"FORD"
"SMITH"
"ALLEN"
"WARD"
"MARTIN"
"TURNER"
"ADAMS"
"JAMES"
"MILLER"
Swarup
At query level it's working when we go to procedure level then the data are not getting as expected