How do i check if a stored procedure and sequence already exists in oracle DB ?
Do we have something like sysobjects in SQL?

Thanks
-Venky

You can check DBA_PROCEDURES and DBA_SEQUENCES (or USER_PROCEDURES and USER_SEQUENCES, if you are the schema owner). Do a DESCribe on these to see what you might want to query, or SPOOL the SELECT and examine the output via Notepad. Or you can try to create a procedure or sequence, using the name you think might already exist. Oracle will give you an error if an object of that type already has that name. (But don't use "OR REPLACE" in your create clause for this check, because then if something does exist by that name it will be replaced by your code).

Thanks. was helpful.