How to get the DDL/Source code of a function in Oracle Enterprise Manager (OEM)

921 views Asked by At

Sometimes we are unable to fetch a source code via dbms_metadata.get_ddl the package then we can use OEM as another way to generate DDL

1

There are 1 answers

0
Rajesh On

After Login to OEM Console -> Select Target -> Databases -> select database -> follow the screenshot.

Screenshot 1: enter image description here

Screenshot 2: enter image description here

Screenshot 3: enter image description here

Screenshot 4: enter image description here

Screenshot 5: (Login with sys as sysdba role) enter image description here

Screenshot 6: (Search the object and select generate DDL from drop down then click on Go) enter image description here

Screenshot 7: (Here is your source code) enter image description here

Now here is the final source code of select function from OEM, like that you can generate the source code of other objects as well.