Question: I need to understand
how to use the dba_editioning_views view. Can
you please explain when to use dba_editioning_views?
Answer: The
dba_editioning_views view describes all editioning
views in the database and consists of three columns.
- owner_name
- table_name
-
view_name
This Oracle tutorial describes the use of editioning views:
"As the hr user, Create editioning views on all tables. Name
the views with the former name of their base tables.
For example, the editioning view on the
table employees_ can be renamed to its former actual name
employees.
CREATE EDITIONING VIEW
employees
AS
SELECT
employee_id,
first_name,
last_name,
email,
PHONE_NUMBER,
hire_date,
job_id,
salary,
commission_pct,
manager_id,
department_id
FROM
employees_;
"
