1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

rowid & rownum along with full table's column

Discussion in 'SQL PL/SQL' started by Puru, Oct 9, 2010.

  1. Puru

    Puru Forum Advisor

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    I want a report which should contain rowid/rownum along with full table's coloumn:welcome
     
  2. SBH

    SBH Forum Expert

    Messages:
    99
    Likes Received:
    6
    Trophy Points:
    160
    Location:
    Bangalore
    You can select rownum n rowid in select query

    SELECT ROWNUM, ROWID, E.*
    FROM EMPLOYEES E
     
  3. Puru

    Puru Forum Advisor

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    Thank you SBH