ThatJeffSmith

Dragging and Dropping Files into Oracle SQL Developer

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

Just mind where you 'drop' it

Just mind where you ‘drop’ it

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.

Second verse, same as the first...

Second verse, same as the first…