Skip to content

Instantly share code, notes, and snippets.

@erdincay

erdincay/oracle select view information

Created July 7, 2020 16:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save erdincay/e0405eaa396ea3f982714dde5dbb650c to your computer and use it in GitHub Desktop.
Save erdincay/e0405eaa396ea3f982714dde5dbb650c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oracle select view information
select o.created,o.last_ddl_time
from user_objects o
where o.object_name='MY_VIEW' and o.object_type='VIEW';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment