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
- 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
- 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
- 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
About the author
David Berry is a software engineer with over 15 years of application development experience. He started developing software in Java 1.0 using an Oracle 7 backend. Making the switch to Microsoft .NET when it was released, he has worked with every version of .NET since. He has also worked with every version of Oracle since Oracle 7 and ever version of SQL Server since SQL Server 7. His experience spans a broad range of industries including semiconductors, financial services, insurance an gove... more