Computer Science & IT – B.Tech, BCA, BBA, MCA, M.Tech Best Online Coaching Institute

Data Types in ORACLE

Data Types in ORACLE

The data type is used to create an object such as table, procedure and package and specify a data type for every column. It has specific storage format, constraints and a specific range of value. An oracle database has a built in data type as well as user defined data type

Here are various data types used in ORACLE:

  1. Character Data type
  2. Numeric Data type
  3. Date Data type
  4. LOB Data type
  5. RAW and LONG RAW Data type
  6. ROWID and UROWID Data type
  • Character Data type

The character data type is used to store character when create the database. It includes national character set or database character set. It is less restrictive and free form text as compare than other data type. For example character can store all alphanumeric values.

Types of Character data Type:

Here are various data types used in character (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Existing Users Log In
 Remember Me