OraFAQ Forum: SQL & PL/SQL » COLUMN

Home » SQL & PL/SQL » SQL & PL/SQL » COLUMN_POSITION

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

COLUMN_POSITION [message #9841]

Mon, 08 December 2003 02:33

resy
Messages: 86
Registered: December 2003

Member

hi,

SELECT column_name, column_position
FROM all_cons_columns
WHERE table_name = 'MYEMP'

while executing this im getting the following error

SELECT column_name, column_position
*
ERROR at line 1:
ORA-00904: "COLUMN_POSITION": invalid identifier

can nybody help me to solve this?

thanx.

Report message to a moderator

Re: COLUMN_POSITION [message #9843 is a reply to message #9841]

Mon, 08 December 2003 03:06

Maaher
Messages: 7065
Registered: December 2001

Senior Member

It's an INVALID COLUMN_NAME. As of Oracle 9i rel. 2 the message has changed from 'invalid column name' to '%s: invalid identifier'. The column you're looking for is 'POSITION'.

MHE

Report message to a moderator

Re: COLUMN_POSITION [message #9846 is a reply to message #9843]

Mon, 08 December 2003 04:32

resy
Messages: 86
Registered: December 2003

Member

thnQ

Report message to a moderator

Previous Topic:	Reg:Schedules.......
Next Topic:	SQL Query Optimization!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:09:40 CDT 2024