-
Course
- Data
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.
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.
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
About the author
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.
More Courses by David