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 Smiley).


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.

About Author

Patrick Barel is a PL/SQL Developer for AMIS Services in the Netherlands. Besides working with SQL and PL/SQL did he co-develop CodeGen and wrote different plug-ins for PL/SQL Developer. He publishes articles on the AMIS Technology blog and on his own blog http://blog.bar-solutions.com/.

1 Comment