Re: SQL to convert from decimal to Binary?
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 3 Dec 2009 06:39:11 -0800 (PST)
Message-ID: <33b4bb63-6fef-4e77-9a4d-229adf4d1021_at_31g2000vbf.googlegroups.com>
On Dec 2, 7:20 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Dec 2, 4:57 pm, CrazyKarma <ska..._at_gmail.com> wrote:
>
> snip
>
> > Is there a readily available function to convert from decimal to
> > binary in SQL? I am not looking for PL/SQL function..plain vanilla
> > SQL.
>
> > Thanks
>
> > ck
>
> Look at the stuff in utl_raw
Date: Thu, 3 Dec 2009 06:39:11 -0800 (PST)
Message-ID: <33b4bb63-6fef-4e77-9a4d-229adf4d1021_at_31g2000vbf.googlegroups.com>
On Dec 2, 7:20 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Dec 2, 4:57 pm, CrazyKarma <ska..._at_gmail.com> wrote:
>
> snip
>
> > Is there a readily available function to convert from decimal to
> > binary in SQL? I am not looking for PL/SQL function..plain vanilla
> > SQL.
>
> > Thanks
>
> > ck
>
> Look at the stuff in utl_raw
You might also find the query posted to the asktom thread on hex to decimal conversion of interest plus there is a link to a number conversion package Tom wrote:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7041297073738
HTH -- Mark D Powell -- Received on Thu Dec 03 2009 - 08:39:11 CST