Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization’s Data

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

M. Malcher, D. KuhnPro Oracle Database 23c Administrationhttps://doi.org/10.1007/978-1-4842-9899-2_9

9. Views, Duality Views, and Materialized Views

Michelle Malcher¹   and Darl Kuhn²

(1)

Huntley, IL, USA

(2)

Morrison, CO, USA

 

Views are used extensively in reporting applications to present data APIs and also present subsets of data to users. One could start to look at views as a way of managing data and of presenting data sets in different ways for applications and users to consume the data. It is not just reading the data either; the capabilities exist to modify the data through the view.

Oracle 23c presents a new feature, JSON duality views, that gives you a ...