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