Re: rawtohex question
From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 25 Jun 2003 12:09:09 +0200
Message-ID: <bdbsfl$rbc8j$1_at_ID-152732.news.dfncis.de>
from dual;
C50851172120
Date: Wed, 25 Jun 2003 12:09:09 +0200
Message-ID: <bdbsfl$rbc8j$1_at_ID-152732.news.dfncis.de>
[Quoted] "marbo" <marbo_at_tpi.pl> schrieb im Newsbeitrag
news:bdbol0$f1j$1_at_nemesis.news.tpi.pl...
> How to do something like this in oracle 8.1 (in 9 it works)
>
> i := to_char(rawtohex(abs(dbms_random.random())));
>
> I'd like to cenvert Interger in HEX.
>
>
> Regards
>
> marbo
>
select
to_char(
rawtohex(
abs(
dbms_random.random
)
)
)
from dual;
TO_CHAR(RAWTOHEX(ABS(DBMS_RANDOM.RANDOM)))
C50851172120
1 Zeile wurde ausgewählt.
What´s the problem ? It worked for me on OEE 8.1.7.3
hth, Jan Received on Wed Jun 25 2003 - 12:09:09 CEST