Escape character inside a select

I am making an "sql from and sql" and need to "reproduce" the single quotation mark: '. Like this.

I put SET ESCAPE ON or SET ESCAPE \ before I do the select. Then the select statement:

select 'select \'Fred is \' || age from test2 ' from test1;

The hard workaround to this is to use double quotes " instead of single '. And then do a searh and replease from the file that I spool this sql statement to. Trying to avoid that. Using Oracle release 7.3

Any ideas?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 02 1999 - 09:55:40 CDT