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]>
('&&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
> -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
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
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
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-
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
#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,'
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
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
10 matches
Mail list logo