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 -
SQL 2021-09-07 03:57:02
how to get the query of a view in oracle
-- 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', 'FLEX_TRADE_AGREG', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEW... Add solution -
SQL 2021-08-28 07:15:02
oracle get view definition
-- 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', 'FLEX_TRADE_AGREG', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEW... Add solution