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: TurkBear <john.greco_at_dot.state.mn.us>
Date: Fri, 11 Apr 2003 12:08:03 -0500
Message-ID: <4htd9vs3s33qigb6k6irr94lvl64j8tp6o@4ax.com>

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

Original text of this message

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