Use this query:
1 | select * from all_objects where upper (object_name) = upper ( 'swc_file_ctl_utl' ); |
Now from the query above use the following fields "owner" and "object_type" you will need these values when you try to get its DDL.
Execute this query for obtaining the DDL:
1 | select dbms_metadata.get_ddl(object_type => 'PACKAGE' , name => 'SWC_FILE_CTL_UTL' , schema => 'APPS' ) |
2 | ddl from dual; |
No comments:
Post a Comment