Enhancements to View Creation and of Virtual Columns Addition

DBMS_JSON.CREATE_VIEW now gives you the option to create a materialized view instead of a standard view. It also gives you the option to specify a particular path so the view can be created on a subset of the data. Both CREATE_VIEW and ADD_VIRTUAL_COLUMN are enhanced to allow automatic resolution of column naming conflicts, to provide a prefix to be applied to column names, and to specify the case-sensitivity of column names.

Enhances development flexibility and allows for materialized views, which may improve query performance with a trade-off against DML performance.

Related Topics