Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reserved SQL word used as column name in a V$ table!
: 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