There are many ways to open a file. File > Open is one, but apparently that’s too boring for many of our friends out there.
For you new-fangled mouse people, let’s look at drag-and-drop.
From the View > Files Panel
Ok, But What About from Explorer or Finder
Same difference, but there is one ‘trick’ to remember – you’ll need a worksheet or editor open first.
Did you stay till the end of the movie? If not, you missed where I showed you can drag multiple files into SQL Developer and have them each opened. This is definitely faster than file > open, file > open, repeat until numb.
But I have a Procedure, Not a Plain Ole SQL Script
Same difference really. You’ll need a worksheet. As soon as we see it’s a stored procedure, we’ll open the Procedure Editor for the file auto-magically.