Why does this not work? (DQuote Escape)

From: Al MacHonahey <savagebeaste_at_yahoo.com>
Date: 11 Apr 2003 09:25:56 -0700
Message-ID: <56184210.0304110825.7ee35632@posting.google.com>

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. Received on Fri Apr 11 2003 - 11:25:56 CDT