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