• Home
  • Ravi Gajula Answers

Answered Questions

  • Jul 10 2005
    03:17 AM
    9099
    11

    What is ROWID

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: Zimmy

    • Jul 10th, 2005

    ROWID is the psedo columns indicate the stored location of the data physically in the database.

    Ravi

    • Jul 3rd, 2013

    ROWID: It is pseudo column,it has physical address location of row in ORACLE database
    The format is: OOOOOO.FFF.BBBBBB.RRR
    OOOOOO is the object ID
    FFF is the file number
    BBBBBB is the block number
    RRR is the row number

    vikas

    • Dec 21st, 2012

    But according to you it has 16 digits ... and according to my oracle 10g it is showing 18 digits. like AAAC9EAAEAAAABXAAA .. why??