RE: Base conversion

2003-01-29 Thread James Howerton
radix.to_dec('&&file',64) FNO , radix.to_dec('&&object',64) OBJECT_ID , radix.to_dec('&&block',64) BLOCK_NUM , radix.to_dec('&&row',64) from dual / Jared Stephen Lee <[EMAIL PROTECTED]>

RE: Base conversion

2003-01-28 Thread Jared . Still
('&&block',64) BLOCK_NUM , radix.to_dec('&&row',64) from dual / Jared Stephen Lee <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/28/2003 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EM

RE: Base conversion

2003-01-28 Thread Stephen Lee
> -Original Message- > Stephen, > > The code I posted earlier is easily adapted to do base 64. > > Please share your mods. :) - OK. I figured out that "A" is zero (I think). Now, only 63 more to go! -- Please see the official ORACLE-L FAQ: htt

RE: Base conversion

2003-01-28 Thread Jared . Still
PROTECTED]> cc: Subject: RE: Base conversion Oracle made rowids base 64. Try to identify a corrupt block number from that when you do "select rowid, last_column_of_table from table;" to see where the thing breaks. Does anyone, perchance, know if they provided a b

Re: Base conversion

2003-01-28 Thread Jared . Still
x.to_dec(radix.to_36(255),36) from dual; - Jared "Grant Allen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/28/2003 07:45 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:B

RE: Base conversion

2003-01-28 Thread Stephen Lee
Oracle made rowids base 64. Try to identify a corrupt block number from that when you do "select rowid, last_column_of_table from table;" to see where the thing breaks. Does anyone, perchance, know if they provided a base 64 converter to go with the base 64 rowids? > -Original Message-

Re: Base conversion

2003-01-28 Thread Igor Neyman
want to use a time-machine to go back and change), we're storing some > information in base-36 (0,1,2,3...8,9,A,B,C,...,Y,Z) in a varchar field. > And you thought hexadecimal was fun :-) > > Now some bright spark would like me to build some PL/SQL to do base > conversion - i

RE: Base conversion

2003-01-28 Thread Kevin Lange
#x27;,13,'D',14,'E',15,'F',16,'G',17,'H', 18,'I',19,'J',20,'K',21,'L',22,'M',23,'N', 24,'O',25,'P',26,'

Base conversion

2003-01-28 Thread Grant Allen
me to build some PL/SQL to do base conversion - in the first instance from base 36 to base 10 (i.e decimal). Has anyone done something similar in the past ... that I could borrow or co-opt? As you've guessed, the deadline is yesterday :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L

Base conversion - WAS: RE: 100% CPU utilization, urgent

2003-01-20 Thread Richard Ji
Can't you just use to_char function to convert from decimal to hex? select to_char(255,'x') from dual; TO_CHA -- ff Richard Ji -Original Message- Sent: Monday, January 20, 2003 3:55 PM To: Multiple recipients of list ORACLE-L > Hussain Ahmed Qadri wrote: > > Thanks for th