-
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
-
SELECT 'ALTER DATABASE BACKUP CONTROLFILE TO '||chr(39)||'D:\xx'||chr(39) FROM DUAL;
-
Type:
SELECT 'ALTER DATABASE BACKUP CONTROLFILE TO ''D:\ORACLE\BKP.CTL'' FROM DUAL;
-
Thank you verymuch selvan
ms_reddy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|