Monday, 14 November 2016

Datatypes in Sql Oracle


Data Types in ORACLE SQL

There are following datatypes in SQL Oracle.

Numeric data types SQL

  • NUMBER datatype in sql
The Number data type is useful when you wants to assign a numeric value to a variable. 

Character data types

  • CHAR
  • NCHAR
  • NVARCHAR2
  • CLOB
  • NCLOB
  • VARCHAR2 and VARCHAR
  • LONG
Datatypes in SQL


Binary data types

  • BLOB
  • LONG RAW
  • BFILE
  • RAW
at 23:44

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)
 
;