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@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 Corporation Received on Fri Aug 06 1999 - 09:14:40 CDT