FLOAT and NUMBER datatypes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: FLOAT and NUMBER datatypes

  1. #1
    Join Date
    Sep 2000
    Posts
    96
    Could someone please explain the differences between the FLOAT and NUMBER datatypes? What situations would be good to use the FLOAT datatype?

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    In internal level of oracle DB no any difference: FLOAT = NUMBER(38)

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Of course there is difference, FLOAT is a subtype of NUMBER!
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Sep 2000
    Posts
    96
    When would I want to use the FLOAT subtype?

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Originally posted by julian

    Of course there is difference, FLOAT is a subtype of NUMBER!
    First question: About what language we are talking SQL or PL/SQL?

    If about SQL then,
    Oracle has 3 classes of datatypes
    -- Oracle Built-in datatypes (internal level) and, Julian, try to find FLOAT there.
    -- ANSI (DB2...) datatypes and Oracle convert its into Built-in datatypes in any way. In this case u can declare FLOAT datatype
    -- Oracle-Supplied Types.

    If about PL/SQL then, u right
    NUMBER has following subtypes for compatibility with ANSI/ISO and IBM types:
    DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INTEGER, INT, NUMERIC, REAL, SMALLINT.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width