Advertisement
Guest User

Untitled

a guest
Apr 26th, 2015
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.16 KB | None | 0 0
  1. select dbms_metadata.get_ddl('MATERIALIZED_VIEW', 'MVIEW_NAME', 'OWNER') from dual;
  2.  
  3. select query from all_mviews
  4. where mview_name = 'your materialized view';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement