What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-01-22 18:46:11
oracle export view ddl
-- Views (use USER_VIEWS or DBA_VIEWS if needed): SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%'); -- Or: SELECT dbms_metadata.get_ddl('VIEW', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEWS or DBA_... Add solution -
SQL 2021-11-05 17:03:16
how to get ddl for materialized view
-- Views (use USER_VIEWS or DBA_VIEWS if needed): SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%'); -- Or: SELECT dbms_metadata.get_ddl('VIEW', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEWS or DBA_... Add solution -
SQL 2021-11-02 16:38:10
ddl materialized view
-- Views (use USER_VIEWS or DBA_VIEWS if needed): SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%'); -- Or: SELECT dbms_metadata.get_ddl('VIEW', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEWS or DBA_... Add solution