Re: QUESTION - "Rulebook" for character delimiting...??

Yep, that would likely be fine.

But I was trying to include some selected data between the double-quotes, so I tried something like:

Select 'sql "select ' || value1 || ' ' || value2 from v\$whatever"'.

it complained that I had an improperly double-quoted string. Which I did.

So I had to isolate the double-quotes on their own, as in

select 'sql ' || '"' || 'alter database rename file ''''' || member ||''''' to ''''' || member || '''''' || '"' || ';' from v\$logfile;

Likely not the most elegant, but oh well.

Now I have to learn awk and sed so I can take this script and change the second 'member' value automagically.

La vida loca.

Thanks!!

chris.hulan_at_gmail.com wrote:
> double-quotes inside single-quotes should work:
>
> select 'a "test" b' from dual;
>
> 'A"TEST"B'
> ----------
> a "test" b
Received on Wed Jun 07 2006 - 13:55:17 CDT