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
[EMAIL PROTECTED]
cc:
Subject:RE: Base conversion
-Original Message-
Stephen
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 FAQ: http
: one of those developer decisions that you
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
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 - in the first instance from base 36 to base 10 (i.e decimal).
Has anyone done something similar
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-
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:Base conversion
For very obscure reasons (read: one of those developer
]
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
base 64 converter to go
-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:
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Base conversion
-Original Message-
Stephen,
The code I posted earlier is easily adapted to do base 64.
Please share your mods
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 the
10 matches
Mail list logo