Re: 'C' Datatypes in ORACLE! Easy Question...
From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 06 Aug 1999 14:14:40 GMT
Message-ID: <37b3ed7c.8389934_at_newshost.us.oracle.com>
9 end;
10 /
123452432142.23435432432
123452432142
Date: Fri, 06 Aug 1999 14:14:40 GMT
Message-ID: <37b3ed7c.8389934_at_newshost.us.oracle.com>
A copy of this was sent to "H. Al-Dhaheri" <phantom_at_emirates.net.ae> (if that email address didn't require changing) On Fri, 6 Aug 1999 17:53:24 +0400, you wrote:
>Hi,
>I'm converting some 'C' functions to PL/SQL under Forms 5. the following
>datatypes are in 'C', do you know the equivalent in ORACLE?
>
>1. long
number(38,0)
>2. double
number
>
>I appreciate any kind of help...thanx in advance...
>Hashem
>
>
see the server concepts manual, it goes over the datatypes.
SQL> declare
2 x number(38,0); 3 y number; 4 begin 5 y := 123452432142.23435432432; 6 x := y; 7 7 dbms_output.put_line( y ); 8 dbms_output.put_line( x );
9 end;
10 /
123452432142.23435432432
123452432142
PL/SQL procedure successfully completed.
-- See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA Opinions are mine and do not necessarily reflect those of Oracle CorporationReceived on Fri Aug 06 1999 - 16:14:40 CEST