Re: Decimal to binary conversion? How?

From: spencer <spencerp_at_swbell.net>
Date: 2000/06/04
Message-ID: <UjC_4.594$Fx6.355627@nnrp1.sbc.net>#1/1

PL/SQL has a datatypes BINARY_INTEGER
and PLS_INTEGER which are "binary numbers". These datatypes are specific to PL/SQL, the Oracle database uses datatype NUMBER for handling numeric data.

DECLARE
  li_mybin BINARY_INTEGER ;
  ln_mydec NUMBER(15) := 123;
BEGIN
  li_mybin := ln_mydec;
END; "Darryl" <djjr_at_ix.netcom.com> wrote in message news:393AE8C8.A78638D7_at_ix.netcom.com...
> Is there any way in sql or PL/SQL to convert a Decimal Number
to a
> Binary Number.
>
> Couldn't find anything in the documentation.
>
> Thanks in advance
>
>
Received on Sun Jun 04 2000 - 00:00:00 CDT