Skip to content

Instantly share code, notes, and snippets.

@marcosvidolin

marcosvidolin/list_views.sql

Last active August 9, 2019 01:40
Show Gist options
  • Save marcosvidolin/96b28dc77eeb5dfe02b73d28b4f45075 to your computer and use it in GitHub Desktop.
Save marcosvidolin/96b28dc77eeb5dfe02b73d28b4f45075 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle - Get views DDL
Raw
list_views.sql
SELECT dbms_metadata.get_ddl('VIEW', view_name) FROM user_views;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment