Expanded Library
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
Why Data Types Matter
18mins
Character Data Types
36mins
- Introduction 1m
- Character Data Types Overview 4m
- Fixed Width (CHAR) vs. Variable Length (VARCHAR2) Data Types 4m
- Demo: Fixed Width vs. Variable Length Character Types 6m
- VARCHAR2, NVARCHAR2, and Character Sets 6m
- Demo: VARCHAR2, NVARCHAR2, and Character Sets 6m
- VARCHAR or VARCHAR2 1m
- RAW Data Type 2m
- Demo: RAW Data Type 5m
- Summary 1m
Numeric Data Types
20mins
Date and Time Data Types
55mins
- Module Overview 2m
- DATE and TIMESTAMP Data Types 4m
- Formatting Date and Timestamp Values 5m
- Getting the Current Date and Time 3m
- Specifying DATE and TIMESTAMP Literal Values in SQL 5m
- Demo: DATE and TIMESTAMP Data Types 6m
- NLS Settings and Date/Time Data 3m
- Functions for Use With DATE and TIMESTAMP Data 3m
- Date Arithmetic 6m
- Demo: Working With DATE and TIMESTAMP Values in SQL 5m
- Interval Data Types 6m
- Demo: Working With Interval Data 6m
- Module Summary 1m
Large Object Data Types
27mins
- Introduction 1m
- CLOB, NCLOB, and BLOB 3m
- LONG and LONG RAW Data Types 1m
- How Large Object Data Types Work 2m
- Creating LOB Columns 2m
- SECUREFILE vs. BASICFILE Option 4m
- TABLESPACE Option 1m
- STORAGE IN ROW Options 2m
- CHUNK Size Option 3m
- CACHE and NOCACHE Options 2m
- COMPRESS Options 3m
- DEDUPLICATE Option 2m
- Summary 1m
