Shulou(Shulou.com)06/01 Report--

Allround Automations is a privately held company based in the Netherlands. Founded in 1989, the company is the world's leading service provider in Oracle development tools. Among them, the product PL/SQL Developer is an integrated development environment, which is specially designed for the development of the stored program unit of the Oracle database. It focuses on the easy-to-use development tools, concise code and high development efficiency, so that you can have a better experience.

The new version of PL/SQL Developer has updated a lot of new features. Some of the contents have been introduced in the previous article. This article is part of the second part. Now follow the editor to see if there are any new features you need.

Enhanced SQL window function

You can now enter column filters for the result set to restrict visible columns based on column names and data types, or to include only required columns or only primary / unique / foreign key columns:

You can enter the filter expression manually (such as "owner,name" above to display all the columns with these two words in the name), or you can press [...] Button to build a column filter:

Added a "compare." Pop-up menu items to compare the contents of the window with the contents of other files.

You can now update the invisible columns in the result set.

The Save Windows State preference now applies to SQL Windows as well.

If you move manually, the vertical splitter position is now retained.

The EXCEL = filename and CSV = filename comment instructions now also support% dd%,%mm% and% yyyy% as variables to the file name.

Enhanced function of program window

Preferences for PL / Scope identifiers have added "Default", "Public", "SQL", and "PL / SQL".

Preferences for PL / Scope statements add "None", "All", and "Default".

Refactoring function key has been added.

Added the Save trailing slash preference.

Now, retrieve the DBMS_Output when the PL / SQL block is executed.

Test window feature enhancement

The Save Windows State preference now also applies to testing Windows.

If the use original case code assistant preference is enabled, the Test feature now uses the original case from the database source to generate function and procedure calls.

The set Log Point item has been added to the margin pop-up menu to quickly define breakpoints that record only information.

Now, when the long-running debugging step is complete, the notification sound is played.

Enhanced command window

CD and DIR commands have been added.

All commands now support environment variables.

Added SHOW ENVVAR

The command window now automatically displays new connection information when the connection changes.

Enhanced beautification of PL / SQL

PL / SQL beautification now supports FETCH FIRST

For the create or replace view command, use PL / SQL to beautify the select statement that now implicitly formats the view. Previously, you had to explicitly mark the select statement.

The Auto Beautification preference can now be enabled for all applicable window types. This used to apply only to program windows.

You can now call PL / SQL beautification when you mark SQL in the session window.

Enhanced table definition editor

Added support for hidden columns (Oracle 12.1 and later)

Enhanced function of the picture window

When you add a table to a chart, you can now choose to add related tables automatically.

The add related Table option has been added to the form pop-up menu.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.