How to Open Package in Toad for Oracle?

Follow these steps to open package in Toad for Oracle.

1. In Toad, click on menu Database > Schema Browser.
2. The schema browser window will open, then select the Packages from the drop-down menu or from the Tab.
3. Then list of packages will be displayed. Select the package you want to open and do the right click on it.
4. From the shortcut menu, click on Load in Editor > then select anyone of the following (Load Both, Load Spec Only, Load Body Only).
5. Then according to your selection the package will be open in the editor. There you can make the changes as well.

See also:

• How to Edit Procedure in Toad
• Oracle TO_DATE function Examples