Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reserved SQL word used as column name in a V$ table!

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

From: <twod_at_not.valid>
Date: 1997/06/13
Message-ID: <5nqpk9$d3j$1@vnetnews.value.net>#1/1

: 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

SELECT "size"
FROM v$db_pipes;

You have a user called 'v$db_pipes' ?

IAP

--
In an attempt to reduce junk email I use an invalid 'From' address.
My correct email address can can be determined by replacing 'not.valid' with 
'value.net'
Received on Fri Jun 13 1997 - 00:00:00 CDT

Original text of this message

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