Monday, March 9, 2015

Get DDL

SELECT dbms_metadata.get_ddl(a.object_type,a.object_name)
FROM user_objects a
where object_type != 'PACKAGE BODY'

By at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...