OraFAQ Forum: SQL & PL/SQL » how to convert number into binary format.

Home » SQL & PL/SQL » SQL & PL/SQL » how to convert number into binary format. (oracle 10g)

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

how to convert number into binary format. [message #443391]

Mon, 15 February 2010 08:22

chaituu
Messages: 115
Registered: June 2008

Senior Member

how to convert number into binary format.

for example if i give value 4 it should convert into binary representation =100
3=011
7=111
8=1000
64=100000000

any build in functions are there in oracle?

EDIT by VK: Removed code tags.

[Updated on: Mon, 15 February 2010 08:32] by Moderator

Report message to a moderator

Re: how to convert number into binary format. [message #443392 is a reply to message #443391]

Mon, 15 February 2010 08:27

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

Senior Member
Account Moderator

Please STOP putting code tags to your post, put it ONLY on code or when alignement is necessary.

There is no built-in function, but is easy to create one.

Regards
Michel

Report message to a moderator

Re: how to convert number into binary format. [message #443394 is a reply to message #443392]

Mon, 15 February 2010 08:31

chaituu
Messages: 115
Registered: June 2008

Senior Member

Thanks for thr reply.i have created one.

Report message to a moderator

Re: how to convert number into binary format. [message #443395 is a reply to message #443394]

Mon, 15 February 2010 08:38

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

Senior Member
Account Moderator

Good! Could you post it.

Regards
Michel

Report message to a moderator

Re: how to convert number into binary format. [message #443397 is a reply to message #443395]

Mon, 15 February 2010 08:42

chaituu
Messages: 115
Registered: June 2008

Senior Member

SELECT 
  DECODE(BITAND(VALUE, 128), 128, '1', '0') ||
  DECODE(BITAND(VALUE, 64), 64, '1', '0') ||
  DECODE(BITAND(VALUE, 32), 32, '1', '0') ||
  DECODE(BITAND(VALUE, 16), 16, '1', '0') ||
  DECODE(BITAND(VALUE, 8), 8, '1', '0') ||
  DECODE(BITAND(VALUE, 4), 4, '1', '0') ||
  DECODE(BITAND(VALUE, 2), 2, '1', '0') ||
  DECODE(BITAND(VALUE, 1), 1, '1', '0') as bin_number from 
(select 8 as value from dual) A;

Report message to a moderator

Re: how to convert number into binary format. [message #443400 is a reply to message #443397]

Mon, 15 February 2010 08:47

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

Senior Member
Account Moderator

Thanks.

I think we already addressed this point some time in the last 3 years but could not find the topic.

Michel

Report message to a moderator

Re: how to convert number into binary format. [message #443403 is a reply to message #443400]

Mon, 15 February 2010 08:52

chaituu
Messages: 115
Registered: June 2008

Senior Member

Michel,

i have one personnel doubt.for every question we post here you will give reply first.i believe not only for my post i think for all other posts you will first reply.how is it possible?will you not sleep? Smile

Report message to a moderator

Re: how to convert number into binary format. [message #443410 is a reply to message #443403]

Mon, 15 February 2010 09:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.psoug.org/snippet/Convert_between_Decimal_Binary_Octal_and_Hex_536.htm

Report message to a moderator

Re: how to convert number into binary format. [message #443411 is a reply to message #443410]

Mon, 15 February 2010 09:50

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

The decimal / hexadecimal conversion is already build into to_char / to_number, too.

SQL> SELECT To_Char(255,'XXXXX') FROM dual;

TO_CH
-----
   FF

SQL>
SQL>
SQL> SELECT To_Number('FF','XXXXX') FROM dual;

TO_NUMBER('FF','XXXXX')
-----------------------
                    255

Report message to a moderator