1) you can paste the code from .sql file (assuming developer gave you the new code in .sql file) in the editor and run the script this will replace the exisiting package.
2) you can double click on the package name from schema browser so that it opens in the editor, replace the code and compile it.
I am not very familiar with Toad, if developer gives modified package, I need to replace this package and compile it .
How to do it in Toad, anyone can tell me steps ?
Thanks a bunch
TOAD is not an Oracle product.
This forum is for Oracle SQL and PL/SQL questions.
How does asking a question about how to use TOAD relate to Oracle SQL and PL/SQL code?
Either look in the help for TOAD directly, or visit the software suppliers website: http://www.quest.com