{"id":3778,"date":"2012-02-17T18:05:59","date_gmt":"2012-02-17T12:35:59","guid":{"rendered":"http:\/\/windowsvj.com\/wpblog\/?p=3778"},"modified":"2012-02-17T18:07:11","modified_gmt":"2012-02-17T12:37:11","slug":"change-keyboard-shortcut-preferences-in-plsql-developer","status":"publish","type":"post","link":"http:\/\/windowsvj.com\/wpblog\/2012\/02\/change-keyboard-shortcut-preferences-in-plsql-developer\/","title":{"rendered":"Change Keyboard shortcut preferences in PL\/SQL Developer"},"content":{"rendered":"

The dichotomy between using various tools for a technology is sometimes confusing. One of the reasons is the keyboard shortcuts for a function in a tool is different in another tool. I too felt this bit irritating while I moved from TOAD for Oracle Developer to PL\/SQL Developer<\/a>tool.<\/p>\n

To run\/execute a query in TOAD user simply need to select the content and press the keyboard shortcut Ctrl+Enter <\/strong>while the same thing was mapped to keyboard shortcut F8 <\/strong>in PL\/SQL developer. And since I am using that version of Dell where I need to press Fn+F8 <\/strong>to actually perform a function what F8 <\/strong>can do it was annoying for me to. Thank fully you can change the keyboard shortcut for a function in PL\/SQL Developer. <\/p>\n

In PL\/SQL Developer, any item in any menu appears in the Key Configuration settings page (under Tools > Preferences > User Interface). And is listed there ready to be assigned a hot key if you want one. The ones I  set up straight away was Ctrl+Enter  <\/strong>for "execute query", followed by Alt-S <\/strong>for "New SQL Window" and Alt-T <\/strong>for "New Test Window". Here is a screenshot :<\/p>\n

\"change<\/a><\/p>\n

Though PL\/SQL is my favorite, Jeff Smith<\/a>, Product manager at Oracle has suggested me<\/a> ORACLE SQL Developer for development and it seemed to be a pretty good tool too and yes it is free.  <\/p>\n

Check out Oracle SQL Developer @<\/p>\n

\"image\"<\/a><\/p>\n

 http:\/\/www.oracle.com\/technetwork\/developer-tools\/sql-developer\/overview\/index.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

The dichotomy between using various tools for a technology is sometimes confusing. One of the reasons is the keyboard shortcuts for a function in a tool is different in another tool. I too felt this bit irritating while I moved from TOAD for Oracle Developer to PL\/SQL Developertool. To run\/execute […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[259],"tags":[],"class_list":["post-3778","post","type-post","status-publish","format-standard","hentry","category-oracleplsql"],"_links":{"self":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts\/3778","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/comments?post=3778"}],"version-history":[{"count":2,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts\/3778\/revisions"}],"predecessor-version":[{"id":3781,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts\/3778\/revisions\/3781"}],"wp:attachment":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/media?parent=3778"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/categories?post=3778"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/tags?post=3778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}