The text oracle object are resides in Tables - user_source;

 SQL :

select name, text, type  from user_source;

SQL :

Select Text from User_Source where Name Like '<oracle object>';

Below are the procedures taken from Toad/Schemas.


CREATE OR REPLACE PROCEDURE HR.greetings
AS
BEGIN
   dbms_output.put_line('Hello sachin keep it good work!');
END;
/

Below are the procedures taken from Toad/Schemas.


SQL> Select Text from User_Source where Name Like 'GREETINGS';

TEXT
--------------------------------------------------------------------------------
PROCEDURE greetings
AS
BEGIN
   dbms_output.put_line('Hello sachin keep it good work!');
END;

SQL> exec GREETINGS;

PL/SQL procedure successfully completed.

SQL> set serveroutput on;
SQL> exec GREETINGS;
Hello sachin keep it good work!

PL/SQL procedure successfully completed.

SQL>