hierarchical query

First Create a temporary table as data of dictionary view ALL_VIEWS and convert column TEXT (view text) to CLOB type. CREATE TABLE tmp_views AS SELECT Read more