Introduction to SQL

SQL Data Type and Operator

Data Type

A data type is a set of data with values having predefined characteristics. Each language has its own data types. Usually, a limited number of such data types come built into a language. The language usually specifies the range of values for a given data type, how the values are processed by the computer, and how they are stored. Some data types in SQL are: char, number, date etc.

The various Data Types along with their description are shown below:

Operators

Oracle provides a set of built-in operators-Arithmetic Operators (+, -, *,), Comparison Operators (=, >, <), Logical operators (NOT, AND, OR). These operators take as input one or more arguments (operands) and return a result.

The various Operators along with their description are shown below in tabular form: