Oracle Developer Essentials: Data Types
By David Berry
This course introduces the most common data types used in tables in Oracle, including CHAR, VARCHAR2, NUMBER, DATE, TIMESTAMP and LOB data types.
Course info
Level
Beginner
Updated
Jan 28, 2015
Duration
2h 37m
Table of contents
Why Data Types Matter
Data Types Introduction
2m
Why Data Types Matter
2m
Examples Where Data Types Matter
7m
DUMP() Function
3m
Demo: Using the DUMP() Function
3m
Summary
1m
Character Data Types
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
Introduction
1m
Oracle NUMBER Data Type
6m
Demo: Oracle NUMBER Data Type
3m
Numeric Data Type Aliases
2m
Identity Columns
5m
BINARY_FLOAT and BINARY_DOUBLE Data Types
2m
Summary
1m
Date and Time Data Types
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
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
Description
Course info
Level
Beginner
Updated
Jan 28, 2015
Duration
2h 37m
Description
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.
About the author
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 from the author
More courses by David Berry