code_junkie

Tools to work with stored procedures in Oracle, in a team?

Nov 11th, 2011
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. SELECT object_type, object_name,
  2. dbms_metadata.get_ddl(object_type, object_name) object_ddl FROM user_objects
  3. WHERE OBJECT_TYPE in ('INDEX', 'TRIGGER', 'TABLE', 'VIEW', 'PACKAGE',
  4. 'FUNCTION', 'PROCEDURE', 'SYNONYM', 'TYPE')
  5. ORDER BY OBJECT_TYPE, OBJECT_NAME
Add Comment
Please, Sign In to add comment