Send your questions to appsdbauniverse@gmail.com

Sunday, February 21, 2016

How to check application object version in Oracle Apps database


set long 10000

select text from dba_source where name = '<object_name>' and type='<object_type>' and rownum < 5;

select dbms_metadata.get_ddl('<object_type>', '<object_name>', '<owner>') from dual;

========================================================================

No comments:

Post a Comment