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

savagebeaste_at_yahoo.com said...
> Ok, this works as expected:
>
> SQL> COLUMN Tname HEADING "Table ""Names"" ";
> SQL>
> SQL> SELECT Table_Name Tname
> 2 FROM User_Tables;
>
> Table "Names"
> ------------------------------
> [...]
>
>
> But why does this not? :
> SQL> 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"'.

-- 
/Karsten
DBA > retired > DBA