OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » RAW TO HEX (11G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RAW TO HEX [message #629590]

Thu, 11 December 2014 07:17

sajeeshts
Messages: 6
Registered: December 2014
Location: Noida

Junior Member

Hi,

I want to get a random nos of digit (alphanumeric) of 32 length, which should be unique.

I am using the below logic, but I am not sure how to get a length of 32 only

SELECT RAWTOHEX(DBMS_RANDOM.VALUE(000000000000000000000000000000,999999999999999999999999999999)) FROM DUAL;

The value I get is of 42 bits.

Can somebody guide me, what value should i input so that I get a length of 32 only ?

Rgds
Sajeesh

Report message to a moderator

Re: RAW TO HEX [message #629591 is a reply to message #629590]

Thu, 11 December 2014 07:22

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

You do realize that it's not possible to get unique random numbers?
If you're using a random number generator you will get duplicate results sooner or later.

Report message to a moderator

Re: RAW TO HEX [message #629592 is a reply to message #629590]

Thu, 11 December 2014 08:22

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle has already done it!

SQL> select sys_guid() from dual;
SYS_GUID()
--------------------------------
04353A2432CF400D8E81809D743E3FFF

1 row selected.

SQL> /
SYS_GUID()
--------------------------------
CF711CCF66364840A64D481C10D81440

1 row selected.

SQL> /
SYS_GUID()
--------------------------------
4F709A7BC7C049019EDD13AB348B85C7

1 row selected.

[Updated on: Thu, 11 December 2014 08:23]

Report message to a moderator

Previous Topic:	Maker-Checker in Oracle
Next Topic:	Getting a word which contains some strings

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 10:39:18 CDT 2024