i want rawid in number format in ora 7.3
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: i want rawid in number format in ora 7.3

  1. #1
    Join Date
    Jul 2001
    Posts
    59
    hi to all,

    i want rawid in number format in oracle 7.3

    reply me at
    mistry_pradip@rediffmail.com

    Pradip Mistry

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I suspect you do not know what you want. What exactly do you wanna extract from the rowid?

    Check the package sys.dbms_rowid

    For example dbms_rowid.rowid_row_number extracts the row number from teh rowid.


  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    get your 7.3 documents and find it

  4. #4
    Join Date
    Jul 2001
    Posts
    59
    hi julian,

    i have search this package in oracle 7.3 it is not there.

    u give full syntex how can i conver rowid into number

    Pradip Mistry

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    In 7.3, ROWID is has the format 'BBBBBBBB.RRRR.FFFF' where BBBBBBBB is the block number, RRRR is the slot(row) number, and FFFF is a file number.

    I hope this helps you.


  6. #6
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    In version 7 didn't exist ROWID.

  7. #7
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    ROWID has been there at least since 6.0.24.

    In 6 and 7 it had the three part format discussed by Julian.

    In 8 it went to a 4 part format.

    I understand in 9 it has mutated again, but I haven't looked into how.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by jrpm
    I understand in 9 it has mutated again, but I haven't looked into how.
    No, AFAIK ROWID format hasn't changed in 9i, it hasn't changed since 8.0.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

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



Click Here to Expand Forum to Full Width