Oracle Objects

Format Models and Data Types

A format model is a character literal that describes the format of datetime or numeric data stored in…
Rowid Data Types

Every row stored in the database has an address. Oracle Database uses a ROWID data type to store…
Datetime Data Types

The datetime data types are DATE and TIMESTAMP. Oracle Database provides comprehensive time zone support for time stamps. DATE Data Type…
Numeric Data Types

The Oracle Database numeric data types store fixed and floating-point numbers, zero, and infinity. Some numeric…
Character Data Types

Character data types store alphanumeric data in strings. The most common character data type is VARCHAR2, which…
Oracle Data types

Oracle Data Types Each column has a data type, which is associated with a specific storage format,…
Overview of Tables

A table is the basic unit of data organization in an Oracle database. A table describes an entity, which…
Types of Objects in Oracle

Database Objects Oracle Database recognizes objects that are associated with a particular schema and objects that…
Oracle Objects

In Oracle, an object is a user-defined data type that can be used to represent a…