How to get ' symbol in the output of a sql.

[ms_reddy]

Hello,

I was trying to generate the output of an sql command as follows:

alter database backup controlfile to 'd:\oracle\bkpctl.ora';

I issued the command as follows:

SQL> SELECT 'ALTER DATABASE BACKUP CONTROLFILE TO '||'''||'D:\ORACLE\BKP.CTL'||''' FROM DUAL;

We have tried using the escape charecter and other alternatives... but we have not found the solution yet.

Any help is appreciated..
Thanks..
Shailender

[tamilselvan]

SELECT 'ALTER DATABASE BACKUP CONTROLFILE TO '||chr(39)||'D:\xx'||chr(39) FROM DUAL;

[LND]

Type:

SELECT 'ALTER DATABASE BACKUP CONTROLFILE TO ''D:\ORACLE\BKP.CTL'' FROM DUAL;

[ms_reddy]

Thank you verymuch selvan

ms_reddy