Where as a column name

From: <bchorng_at_my-deja.com>
Date: Tue, 31 Aug 1999 22:18:00 GMT
Message-ID: <7qhkac$c1q$1@nnrp1.deja.com>

There is a column named " where " in v$latch_misses in 8.0.5. I tried the following query and it failed, because Oracle mistakes the column " where " for the where clause and takes it as syntax error although this query is absolutely legal.

I consider this an Oracle bug.

Does anybody know if there is any escape key for SQL ? -Bass Chorng

---

desc v$latch_misses

 Name                            Null?    Type
 ------------------------------- -------- ----
 PARENT_NAME                              VARCHAR2(50)
 WHERE                                    VARCHAR2(64)
 NWFAIL_COUNT                             NUMBER
 SLEEP_COUNT                              NUMBER
 WTR_SLP_COUNT                            NUMBER
 LONGHOLD_COUNT                           NUMBER

select parent_name, where from v$latch_misses where rownum <= 100;

select parent_name,where from v$latch_misses

                   *

ERROR at line 1:
ORA-00936: missing expression

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 31 1999 - 17:18:00 CDT