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

To get the most out of this book

To get the most from this book, it is recommended to have basic knowledge of SQL and PL/SQL, as well as the architecture of Oracle Database. It is also recommended to have an Oracle Cloud account and an autonomous database provisioned, at least using the Always Free version to test and implement solutions practically.

Software/hardware covered in the book

Oracle SQL Developer Desktop or any other developer tool for data management

An Oracle Cloud account

Please note that the process of provisioning and installation is described in Chapter 1, Oracle Cloud Fundamentals.

If you are using the digital version of this book, we advise you to type the code yourself or access the code from the book’s GitHub repository (a link is available in the next section). Doing so will help you avoid any potential errors related to the copying and pasting of code.

The rest of the chapter is locked

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

Table of Contents (26) Chapters

To get the most out of this book

Authors (1)

Personalised recommendations for you

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

Table of Contents (26) Chapters

To get the most out of this book

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you