In focus

Content Filter

Complexity Level

Search Column

  • Data Types In Oracle
    Apr 26, 2016. In this article we will discuss about the built-in datatypes in Oracle. In oracle, each ‘column value’ and constant in SQL expression has a ‘DataType’.

About Column

A Column is a vertical group of values within a table that contains values from a single field in multiple rows. In the databases Column may be defined as individual fields within a table with have different values and each field has a name, such as Name, Address and Phone Number etc. So that when multiple values from a column are selected, they will all have similar information such as a list of phone numbers. When defining Columns in databases and spreadsheets then it is must be specify the type of data, such as a string, number, or date. This helps ensure all the data within a given column has a similar format.