Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Why does this not work? (DQuote Escape)
The COLUMN syntax is SqlPLus not Sql..
The Select statement follows Sql syntax rules for aliases so has problems with quoted quotes..
savagebeaste_at_yahoo.com (Al MacHonahey) wrote:
>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.
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Fri Apr 11 2003 - 12:08:03 CDT
![]() |
![]() |