From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Overview of table data types

Overview of table data types - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

Overview of table data types

“

- [Instructor] Another important concept we need to understand before we can start practicing demos of the SQL language is the concept of Datatypes. Every database table is made out of one or more columns, as we saw in our previous video. When we create a database table in Oracle, in addition to specifying the column names, we also have to assign a Datatype for each column. So for example we can assign the Number Datatype to the ID column and the VARCHAR2 datatype to the Name column. By the way, in Oracle, VARCHAR2, which is short for Variable Character 2, is used to store strings in the database. And the Hiredate column could be of the Date Datatype. Many different Datatypes exist in the Oracle database and we have to specify the Datatype for each column during table creation. We'll see examples of this later in our course. Now why is this important? Because specifying the Datatype for a column can help us insure integrity of our data. For example, if we specify that the ID column in…

Contents