Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: QUESTION - "Rulebook" for character delimiting...??

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

From: BD <bobby_dread_at_hotmail.com>
Date: 7 Jun 2006 11:55:17 -0700
Message-ID: <1149706517.212553.160430@i40g2000cwc.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US