SQL Developer Tips

       Inspired by Jeff Smith's post on SQL Developer, the tools which i am using for over two years

I have decided to blog on the same lines as Jeff - about the tricks and tricks which can save time for the developers when using SQL Developer.

Today's Tips is about the short cut keys to open the Object details / source codes of any objects like Procedures or any functions If yo are int eh middle of coding and you want to see the source code of a procedure you use. Simply select the procedure and Press Shift + F4 . The source code will open in a seperate window. For example, I have selected ADD_JOB_HISTORY procedure and upon pressing Shift + F4 keys the source code opens up.

 

Source code of this Procedure opens up as :