PL/SQL Developer is an integrated development environment dedicated to the development of the Oracle database’s stored program unit. It pays attention to the development tool is simple to use, the code is concise and the development efficiency is high characteristic, uses very convenient.

Click to download the latest version of PL/SQL Developer

PL/SQL Developer has now been updated to version 13.0, with many new features

The load test

With the new Load Tester tool, you can perform stress and concurrency tests for Oracle data and programs. This allows you to find performance issues and solve problems with multi-user scenarios, and test optimization results.

You can define steps, substeps, and loops to execute specific SQL statements, or PL/SQL blocks to mimic user behavior for a particular application. For each step, you can define execution properties, such as SQL text, repetition, and delay, as well as variables that generate random data or fetch data from previous steps:

You can specify the number of concurrent threads that will perform these steps and which Oracle accounts should be used. Performance results can be viewed in real time as text, bar charts, or line charts:

Editor enhancement

  • After selecting a column using alt-Select, you can now type new text for that column. The newly typed text is repeated on each row of the column selection.

  • You can now increase or decrease the editor font size by pressing Ctrl +/- on the numeric keypad.

  • The Go to Line feature now has the option to move relative to the beginning of text, cursor position, or SQL start position:

  • When the cursor is over the insert column list, the editor highlights the corresponding value expression. Previously this only worked if the cursor was in the insert value list.

  • The editor now highlights all table.column events in the SELECT statement when clicking a table name in the statement:

  • The editor now highlights all field events in the SELECT statement when a field in the statement is clicked:

  • Added function keys for collapse and expand operations.

  • A new repeat line function key has been added.

  • A new “Editor: First character online” function key has been added.

  • A new “Remove Unindents” preference was added. When enabled, pressing the Delete key removes all tabs and Spaces to the right of the cursor position.

Code assistant enhancement

  • A new filter method option has been added. You can set it to “Contains” to show all items that contain the filter text, or to “Starts with” to show all items that begin with the filter text (the previous behavior) :

  • Code Assistant will now display a list of directories after typing @ in the command window:

Find and replace enhancements

  • When regular expressions are used, support for special characters (such as \ t) and subexpression (such as $1) is added to the replacement text.

  • There is now a separate recall history of regular expressions.

  • Now, when using regular expressions, the list of syntactic options for finding and replacing text is as follows:

PL/SQL Developer V13.0 is not finished yet, please check out the following content