Inside Oracle APEX: SQL Workshop - Commands: Keyboard Shortcut

Wednesday, June 06, 2007

SQL Workshop - Commands: Keyboard Shortcut

Did you know that you can use the keyboard shortcut Ctrl+Return in the SQL Commands textarea of the Oracle APEX SQL Workshop application to execute the current SQL statement?

That's really nice, especially if you are used to it from PL/SQL Developer/TOAD.

Labels: APEX, Oracle, tips

del.icio.us digg dzone furl reddit technorati

4 Comments:

that's a great shortcut key indeed. Much better than grabbing your mouse and find the "run" button over and over again.

By Patrick, at 07 June, 2007 09:01
Patrick,

The only problem is when you keep on pressing F5 (SQL Developer style), which, of course, in the browser refreshes the window and you lose your query!! Annoying!

Another neat trick with the SQL Workshop worth mentioning here is the ability to select a section of a query to run, very useful when debugging.

Anthony.

By Anthony Rayner, at 08 June, 2007 20:08
That's a nice one! Didn't know that either.

But maybe because I only use the SQL Workshop when it's the only possibility (like on apex.oracle.com). Normally I tend to use a "real" IDE for coding/writing queries, like PL/SQL Developer.

Patrick

By Patrick Wolf, at 08 June, 2007 20:27
Hi guys,

the two tricks even work in combination. I often have multiple sql scripts together in the textarea.

Then I can use the keyboard or the mouse to highlight one statement and press CTRL-ENTER to execute it. Really convenient.

Regards,
~Dietmar.

By daust_de, at 20 January, 2008 20:46