Youtube Channel

Oracle Data Types



DATA TYPES :

DATA TYPEDESCRIPTIONMAX SIZE
VARCHAR2(SIZE)
  • Variable length character string having maximum length size bytes.
  • You must specify size. We can use to store string values.
  • 4000 bytes
  • minimum is 1
NUMBER(SIZE)
  • Number having precision P and scale S, which we can use to store number values.
  • The precision P can range from 1 to 38.
  • The scale can range from -84 to 127.
DATE
  • Valid Date range . We can use to store Date values

    NULL : It is not a value and does not occupy any space.

    TABLE: Table is the basic element in a database or object in database to store the data in the form of rows and columns.


    Next PostNewer Post Previous PostOlder Post Home

    0 comments: