Reserved SQL word used as column name in a V$ table!

From: Ben Ryan <ben_ryan_at_vancity.com>
Date: 1997/06/10
Message-ID: <5nk7ql$69c$1@sisyphus.tvinet.com>#1/1

[Quote from PL/SQL Reference 2.3, Appendix E. - Reserved words]

The words listed...should not be used to name database objects such as columns, tables, or indexes.

..

size*
..

NB. A * means the word is reserved in both PL/SQL and SQL.

describe v$db_pipes

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNERID                                  NUMBER
 NAME                                     VARCHAR2(1000)
 TYPE                                     VARCHAR2(7)
 SIZE                                     NUMBER

SELECT v$db_pipes.size FROM v$db_pipes;
                  *

ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or column specification

I guess it is another test (by the developers) of our ingenuity. Is there a way to list out the column without using a * in the column list?

Ben Ryan - VanCity C.U.
Vancouver, B.C.
Canada Received on Tue Jun 10 1997 - 00:00:00 CDT