-
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,
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,