1. Home
  2. Flashcards
  3. Preview

Oracle

  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.
Author
wgaynor
ID
263450
Card Set
Oracle
Description
Data Types
Updated

  1. Home
  2. Flashcards
  3. Preview