Results 1 to 4 of 4

Thread: Column_position

  1. #1
    Join Date
    Nov 2003
    Posts
    87

    Lightbulb Unanswered: Column_position

    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.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    it is always a good idea to state oracle version and platform.
    As of 8i the column name is position ...

  3. #3
    Join Date
    Nov 2003
    Posts
    87

    Talking

    I got the correct result when i changed the query like this..

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

    thanx

  4. #4
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    You are right , ALL_CONS_COLUMNS doesn't have a column 'COLUMN_POSITION'.
    SATHISH .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •