- Course
Oracle Developer Essentials: Data Types
This course introduces the most common data types used in tables in Oracle, including CHAR, VARCHAR2, NUMBER, DATE, TIMESTAMP and LOB data types.
Beginner
- Course
Oracle Developer Essentials: Data Types
This course introduces the most common data types used in tables in Oracle, including CHAR, VARCHAR2, NUMBER, DATE, TIMESTAMP and LOB data types.
Beginner
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
This course introduces the most common data types that are available in Oracle. Selecting the correct data type is very important in creating a database design, so it is important to know what data types are available and their capabilities. This is intended to be an introductory level course that will make sure you understand how to choose the data type that best fits your needs.
Oracle Developer Essentials: Data Types
Beginner
Table of contents
-
Introduction | 1m 6s
-
Character Data Types Overview | 3m 42s
-
Fixed Width (CHAR) vs. Variable Length (VARCHAR2) Data Types | 4m
-
Demo: Fixed Width vs. Variable Length Character Types | 5m 39s
-
VARCHAR2, NVARCHAR2, and Character Sets | 6m 28s
-
Demo: VARCHAR2, NVARCHAR2, and Character Sets | 6m 2s
-
VARCHAR or VARCHAR2 | 59s
-
RAW Data Type | 1m 46s
-
Demo: RAW Data Type | 4m 31s
-
Summary | 1m 5s
David Berry is a software engineer with over 15 years of experience developing applications in languages such as Java and C#. Throughout his career, he has worked extensively with enterprise database systems including Oracle and SQL Server.