You're reading from Developing Robust Date and Time Oriented Applications in Oracle Cloud A comprehensive guide to efficient date and time management in Oracle Cloud

Product type Paperback

Published in May 2023

Publisher Packt

ISBN-13 9781804611869

Length 464 pages

Edition 1st Edition

Languages

SQL

Tools

Oracle Database

Concepts

Databases

Author (1):

Michal Kvet

View More author details

Table of Contents (26) Chapters

Preface

1. Part 1: Discovering Oracle Cloud

2. Chapter 1: Oracle Cloud Fundamentals FREE CHAPTER

3. Chapter 2: Data Loading and Migration Perspectives

4. Part 2: Understanding the Roots of Date and Time

5. Chapter 3: Date and Time Standardization Principles

6. Chapter 4: Concepts of Temporality

7. Part 3: Modeling, Storing, and Managing Date and Time

8. Chapter 5: Modeling and Storage Principles

9. Chapter 6: Conversion Functions and Element Extraction

10. Chapter 7: Date and Time Management Functions

11. Chapter 8: Delving into National Language Support Parameters

12. Part 4: Modeling Validity Intervals

13. Chapter 9: Duration Modeling and Calculations

14. Chapter 10: Interval Representation and Type Relationships

15. Chapter 11: Temporal Database Concepts

16. Chapter 12: Building Month Calendars Using SQL and PL/SQL

17. Part 5: Building Robust and Secure Temporal Solutions

18. Chapter 13: Flashback Management for Reconstructing the Database Image

19. Chapter 14: Building Reliable Solutions to Avoid SQL Injection

20. Part 6: Expanding a Business Worldwide Using Oracle Cloud

21. Chapter 15: Timestamp Enhancements

22. Chapter 16: Oracle Cloud Time Zone Reflection

23. Assessments

24. Index

Why subscribe?

25. Other Books You May Enjoy

Exploring NLS parameters and their impact

In order to be able to prepare a universal solution that can be deployed anywhere in the world, it is necessary to know the regional characteristics and formats and adapt the solution to your specific environment and customs. The aim of this section is to introduce you to individual NLS parameters and show you how to create a robust solution for various specific elements of date and time processing and representation.

We will look closely at parameters directly related to date and time processing. Toward the end of the chapter, we will see a summary of a few other parameters that are outside of the scope of this book.

We will start with NLS_DATE_FORMAT, followed by NLS_DATE_LANGUAGE, NLS_CALENDAR, and NLS_TERRITORY. By learning about them, you will be able to implement sophisticated solutions directly tailored to specific clients’ requirements in any region and on a global scale.