Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT object_type, object_name,
- dbms_metadata.get_ddl(object_type, object_name) object_ddl FROM user_objects
- WHERE OBJECT_TYPE in ('INDEX', 'TRIGGER', 'TABLE', 'VIEW', 'PACKAGE',
- 'FUNCTION', 'PROCEDURE', 'SYNONYM', 'TYPE')
- ORDER BY OBJECT_TYPE, OBJECT_NAME
Add Comment
Please, Sign In to add comment