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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Why does this not work? (DQuote Escape)

Re: Why does this not work? (DQuote Escape)

From: Islaw <islaw_at_adexec.com>
Date: Fri, 11 Apr 2003 21:02:27 GMT
Message-ID: <D3Gla.86$iZ.11085010@newssvr13.news.prodigy.com>


Karsten Farrell wrote:

> savagebeaste_at_yahoo.com said...

>> Ok, this works as expected:
>>
>>> COLUMN Tname HEADING "Table ""Names"" ";
>>>
>>> SELECT Table_Name Tname
>> 2 FROM User_Tables;
>>
>> Table "Names"
>> ------------------------------
>> [...]
>>
>>
>> But why does this not? :
>>> SELECT Table_Name "Table ""Names"" "
>> 2 FROM User_Tables;
>> SELECT Table_Name "Table ""Names"" "
>> *
>> ERROR at line 1:
>> ORA-03001: unimplemented feature
>>
>> wtf? This error makes no sense. According to any reference book I've
>> checked (mainly the O'Rielly ones), " ""blah"" " or ' ''blah'' '
>> should work for (double)quote escapes. So why does it not work in an
>> explicit heading in a SELECT???
>>
>> Thanks to anyone who can clear up this mystery.
>>
> Although an alias appears in the heading of the output, that does not
> mean it's a heading. It's an alias, and an alias can't have a name
> like 'Table "Names"'.

Odd, I just checked it in 8i (8.1.5) and it works in both cases. However, I tried in 9i (9.2.0.1.0) at home (8i I have at work... dont ask.) In 9i I get the same error the OP gave.

Looks like some sort of compatibility problem.

--
Islaw
Received on Fri Apr 11 2003 - 16:02:27 CDT

Original text of this message

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