Edit Package

[IncredibleMrT]

Hi,
When right clicking on a package to edit, you get 'EDIT' or 'EDIT SPEC & BODY'

'EDIT' will just edit the spec.
Could you add an option to just edit the body?

Thanks
Matt.

 

[Jens Naumann]

Hi, to get this You must select the node 'Package bodies' in the object explorer.
Regards

 

[IncredibleMrT]

Hi, to get this You must select the node 'Package bodies' in the object explorer.
Regards

Thanks Jens.
Yes, you do,
I was meaning more from when you've got a chunk of SQL in a window, and you right click there. Otherwise it means having to search for it. I know, not a major issue - more a time saver.

select t.* from table(pkg.tbl_fun) t;

 

[William Robertson]

My advice would be never to edit source code directly in the database. I keep that option disabled in the preferences.

 

[Ivan C.]

Just ctrl+right-click the function name in the SQL Window. That'll open the package body in a new Program Window, while positioning the cursor on the beginning of function's code.