Tag: hierarchical query

First – create temporary table as data of dictionary view ALL_VIEWS and convert column TEXT (view text) to CLOB type

CREATE TABLE tmp_views AS SELECT a.owner , a.view_name,