Dear All,
I have created one procedure in SCOTT schema. just i need to see that same procedure information to TEST schema. how its possible.
if im using SELECT DBMS_METADATA.GET_DDL('PROCEDURE','PROC_NAME','SCOTT') FROM DUAL in scott schema mean i can see that full procedure information,
like wise i need to see in TEST schema mean what command i need to use.
Thanks ALL...