-
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!
-
try:
select rownum, name, phone from yourtable
Jeff Hunter
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|