Oracle

Card Set Information

Author:
wgaynor
ID:
263450
Filename:
Oracle
Updated:
2014-02-24 21:58:34
Tags:
Datatypes
Folders:
DataTypes
Description:
Data Types
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user wgaynor on FreezingBlue Flashcards. What would you like to do?


  1. Character
    • CHAR (default size is 1)
    • NCHAR
    • VARCHAR2 (must always specify size)
    • NVARCHAR2
  2. NUMBER
    • NUMBER
    • FLOAT
    • BINARY_FLOAT
    • BINARY_DOUBLE
  3. Long and Raw
    • LONG
    • LONG RAW
    • RAW
  4. Large object
    • CLOB
    • NCLOB
    • BCLOB
    • BFILE
  5. Row ID
    • ROWID
    • UROWID
  6. Value = 123.2564
    Datatype = NUMBER
    What is the stored value?
    123.2564
  7. Value = 1234.9876
    Datatype = NUMBER(6,2)
    What is the stored value?
    1234.99
  8. Value = 12345.12345
    Datatype = NUMBER(6,2)
    What is the stored value?
    • Error;
    • range of integer part is only from -9999-9999
  9. Value = 1234.9876
    Datatype = NUMBER(6)
    What is the stored value?
    • 1235
    • The decimal part is rounded to the next integer
  10. Value = 12345.345
    Datatype = NUMBER(5,-2)
    What is the stored value?
    • 12300
    • The negative scale rounds the number<s> digits left to the decimal point.

What would you like to do?

Home > Flashcards > Print Preview