KC: PL/SQL Developer

Yesterday evening we had a nice, interactive, session about PL/SQL Developer. Theo Tol (BI4U) came by to tell us more about the tool and how it can be used. There was some nice information on the different windows for the different tasks and then there where some tips on how he thinks it’s easier to work with this tool. Since he has 7+ years of experience, I find most of his tips quite useful, although some of them we figured out together when we were working for the same company (in a previous life ).

One of the tips he mentioned was changing the short-cut for code completion from F6 to CTRL-Space. This is lots easier when you’re a blind typist (and it’s the same as it is in the Delphi IDE). Another tip is to put your frequently used connect strings in the pop-list of the connect button. Use the “>” to create submenus to group certain connect string, for example for different databases.

Then there were some plug-ins he mentioned. All of these can be found at the Allround Automations site or at the Bar Solutions site. There’s a plug in for PL/SQL Doc (like javadoc), the browser extender and one of my favorites (my own) Comment-Lines plugin.

The presentation (in dutch) can be downloaded, using this link.