How to check if a stored procedure is exist........?

Oracle data dictionary also called as system catalogue.the data dictionary  which contain information about database.

1.The data dictionary contains defination of all schema objects in the database,that is tables,view,stored procedure,sequences,synonyms,indexes etc.

2.it also privides information about how much space has been allocated for these schema objects.


How to check if a stored procedure is exist........?

You can try this Example:-


How to find which procedure are  being used in database for example name..?

Example is as follows....

SELECT * FROM USER_OBJECTS
WHERE OBJECT_TYPE='PROCEDURE';


SELECT *
FROM USER_PROCEDURES;


When You need to get all defination of procedures like source code or text  to achive this task
we can enter this select statement.

SELECT * FROM USER_SOURCE