fixed_view_text.sql

This script extracts the SQL statement text for all the V$ views. The V$ views are based on the X$ tables, and reading the SQL statements for these views is the best way to develop an initial understanding of the X$ tables.

select
'create view ' || view_name || ' as ' || view_definition || ';'
from
sys.v_$fixed_view_definition
order by
view_name