PL/SQL Developer is an IDE (Integrated Development Environment) that is specifically targeted at the development of stored program units for Oracle Databases. Over time more and more business logic and application logic has moved into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages during Oracle application development.
Updates in V9.0.1
Multiple simultaneous connections
The major new feature in PL/SQL Developer 9.0 is that you can now be connected with more than one user at more than one database at a time. Each window has its own connection, and you can easily switch the connection of a window by using the connection selector.
Connection List
Allows you to quickly access connections from a dockable or floating tool. The connection list gives you a quick overview of all connections and their associated windows. Connections will automatically be added to the list when logging on, but they can also be explicitly added as a user-defined connection.
XLSX format support (Excel 2007 / 2010)
Added support for Excel 2007 / 2010 XLSX format for exporting SQL Window result sets and saving Report Window results. The XLSX format allows for an unlimited number of rows per sheet.
Table Definition Editor
Enhancements
Now supports Oracle11g virtual columns. You can mark a column as virtual and enter the expression in the Default/Expression field.
Diagram Window Enhancements
- Explicitly sort items with drag & drop
- Automatically sort items by id or alphabetically
- Additional zoom levels for smoother zooming
- Show or hide item types at group or diagram level
- Table and View level comments included
Command Window Enhancements
- ZIP Archive [File | Directory] command added
- Support for SIZE UNLIMITED added for the SET SERVEROUTPUT command
- ZIP option added to the SPOOL command
- SHOW CONNECTION command added to show information about all connections
Other Enhancements
- Support for local partitioned indexes added
- Support for logging/no-logging added
- Support for rowdependencies added
- Comments can now be edited in a text editor
SQL Window Enhancements
- You can now lock one or more columns so that they remain visible when the grid is scrolled horizontally. You can also scroll lock rows to keep key rows visible or to easily compare 2 rows that are not adjacent
- Virtual columns are read-only and will immediately update when you change the value of a source column
- If a table has a before insert or update trigger that modifies column values, or if the table has default values for newly inserted records, the SQL Window grid will now immediately display these server-generated values after posting the new or modified record
- You can now use a "Tab=<title>" comment to define result tab titles
- A function key has been added to invoke the Large Data Editor from the result grid
- The Output Buffer Size can be set to 0 for Unlimited
Test Manager Enhancements
- Global variables added to pass variable values from one test script to another
- A "New Session" property is added to isolate test scripts from session state changes
- A Log pane is added on the Run tab page to show variable input and output values
- The definition page now contains a splitter to resize the top and bottom half
Editor Enhancements
- Syntax highlighting now works correctly for alternative quote delimiters
- The Code Assistant is now invoked for database links after typing @
- Code Assistant "Describe Context" queries can now be modified through CANames.sql
- The editor now detects Unicode encoding from the file contents in addition to the file header ("BOM")
- The macro recorder now supports edit functions like Find, Bookmark, and so on
- Ctrl-Del is now assigned to "Editor / Delete next word"
Object Browser Enhancements
- A "Suppress owner" property has been added for user-defined Object Browser Folders
- The list of users for the User selector can now be limited by specifying a where clause in the Preferences
File Browser Enhancements
- Popup menu item "Open with" added to open a file with an external program
- Popup menu item "Properties" added to show the file properties
- Popup menu item "Open in Explorer" added to show a file or directory in the Windows Explorer
Data Generator enhancements
- SQL() expression now accepts bind variables for other field values. For example: SQL('Department ' || :deptno)
- LIST(select) expression now accepts bind variables for other field values. For example: LIST(select empno from emp where deptno = :deptno)
- SQL() expression now accepts a select statement with a single column/row result. For example: SQL(select count(*) from order_lines where order_id = :order_id)
Compare User Objects Enhancements
Now allows you to compare PL/SQL source objects with or without case, white space, and comments. Simply select the corresponding items on the options tab page: The difference viewer will also compare with or without case and white space. If you are using your own difference viewer, you can configure which command-line switches need to be used for each option.
About Allround Automations
Allround Automations, based in Enschede, The Netherlands, is a privately held company, founded in 1989. Allround Automations is a leading provider of Oracle development tools, with more than 290,000 users at more than 40,000 companies and organizations in 147 countries.
