DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: i want rawid in number format in ora 7.3

  1. 11-30-2001, 05:55 AM #1
    pbmistry
    pbmistry is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 11-30-2001, 06:07 AM #2
    julian
    julian is offline Senior Advisor
    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.

    Reply With Quote Reply With Quote
  3. 11-30-2001, 06:18 AM #3
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    get your 7.3 documents and find it
    Reply With Quote Reply With Quote
  4. 11-30-2001, 06:18 AM #4
    pbmistry
    pbmistry is offline Junior Member
    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
    Reply With Quote Reply With Quote
  5. 11-30-2001, 06:57 AM #5
    julian
    julian is offline Senior Advisor
    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.

    Reply With Quote Reply With Quote
  6. 11-30-2001, 06:59 AM #6
    aarroyob
    aarroyob is offline Senior Advisor
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    In version 7 didn't exist ROWID.
    Reply With Quote Reply With Quote
  7. 11-30-2001, 12:49 PM #7
    jrpm
    jrpm is offline Senior Member
    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'
    Reply With Quote Reply With Quote
  8. 11-30-2001, 05:34 PM #8
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width