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

Ben Ryan wrote:
>
> ..
>
> 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
>

Ben,

you are able to query those views or tables by using quotation marks. The column name is case sensitive :

select 'SIZE' from v$db_pipes;

This should work.

Good luck

Detlev

-- 
Detlev Goebel

mailto:detlev.goebel_at_gzs.de
---------------------------