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

Thread: Hex to decimal conversion!!!!!!!

  1. #1
    Join Date
    Apr 2001
    Location
    Romania
    Posts
    2

    Question

    Is there any method to convert a hex value ( rawtohex(rowid)) into a decimal value? I have a table:

    name phone
    --------------
    a 112
    b 3212
    c 212
    d 313

    I must receive the following resultset:

    no name phone
    -----------------
    1 a 112
    2 b 3212
    3 c 212
    4 d 313

    I try with the rowid value but it is a hex value and I can't convert her to a decimal format (there is no built in function to do this) .
    Please send me urgently the answer to istoican@intrarom.ro
    Thanks!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    try:

    select rownum, name, phone from yourtable
    Jeff Hunter

  3. #3
    Join Date
    Apr 2001
    Location
    Romania
    Posts
    2

    Lightbulb

    Thanks!
    Shame on me! It was so simple!

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