Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. Nuijten, P. BarelModern Oracle Database Programminghttps://doi.org/10.1007/978-1-4842-9166-5_18

18. See What You Need to See

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

If you store data in the database, it does not have to be visible to everyone at any time. Sometimes you don’t want people to see your data. Sometimes you want certain groups to see your data and others not. And sometimes you want your data to be available at a certain period. Oracle Database provides different mechanisms for these issues.

Temporal Validity

Sometimes the data in our database is only valid for a certain ...