Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Conversion to binary representation of a number

xxsawerAug 27 2013 — edited Aug 27 2013

Hi,

Is there any function in PL/SQL which would convert a number to its binary representation? Resulting datatype would be VARCHAR2.

So for example if I would have number with value of 9 then I would need 1001 as a result.

I was trying to find this in TO_CHAR formatting models but didn't find anything.

Thanks for help,

Dan
This post has been answered by Karthick2003 on Aug 27 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2013
Added on Aug 27 2013
5 comments
1,515 views