mygicavietnam.comJuly 2, 20200Allround, application, Automations, databases, Developer, development, environment, Oracle, PL-Squốc lộ, v14.0.1.1965, x64, x86


PL/Squốc lộ Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have sầu seen more và more business xúc tích and application logic move 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 và productivity, key advantages during Oracle application development.

Bạn đang xem: Allround automations pl/sql developer 14

Built-in Version Control tư vấn for Git và Subversion

If you are using Git or Subversion (SVN) for version control, you can now make use of the built-in version control functions in PL/SQL Developer.

The version control status of a file (untracked, added, modified, unchanged, …) will be displayed in window status lines, in File Browser items, and in Project items.

Version control operations can be performed directly in a window by clicking on the version control status icon:


In the File Browser và in a Project you can right-cliông xã on an item to persize a version control operation:


For these file control operations PL/SQL Developer relies on a 3rd các buổi party shell extension that must be installed on your system. In the screenshots above sầu “GIT Extensions” has been used.


A workset is a mix of Program Windows, Squốc lộ Windows, Test Windows, Commvà Windows, Report Windows và Diagram Windows that you are working on. Changes made lớn these windows are preserved when closing and reopening PL/Squốc lộ Developer, even if you have not explicitly saved or compiled these changes. After finalizing your work you can apply the workset, so that changes to the files & database objects are permanently saved.

A workset holds the window contents, sizes and positions. When a workset is reopened later, windows will be restored exactly like they were previously used.

When using multiple worksets you can easily switch between them, or use the workset= command-line parameter.

All workset-related functions are accessible from the Workmix group on the File ribbon:


Internal difference viewer

Several PL/SQL Developer functions allow you to compare 2 texts và display the differences. These differences can now be viewed in an internal difference viewer, instead of relying on an external tool:


The new viewer allows you to lớn ignore differences in case và Trắng space as usual, but it can also ignore differences in comments.

For modified lines it will mark the exact differences within the lines.

Program Window enhancements

The Program Window now highlights transaction statements, so that you can visually recognize the code that affects a transaction. As soon as you place the cursor on a transaction statement, all related statements within a program unit will be highlighted:


Using the “Test” và “Describe” functions in the Code Contents of a Program Window now automatically selects the correct overloading.A preference option has been added to prefix filename with owner when saving a database sourcePerformance has been improved when fetching large database sources over a slow connection

Debugger enhancements

A variable name & value can now be copied khổng lồ the clipboard through the new “Copy variable” popup menu nhà cửa.

Editor enhancements

A function key “Editor: Refresh Code Assistant” has been added, to lớn bring the Code Assistant up khổng lồ date after creating new database objects.When selecting a word, all matching words will be highlighted.Marked editor text is automatically copied to the tìm kiếm field of the Find function.

Squốc lộ Window enhancements

You can now display multiple result sets simultaneously và can compare them:


CLOBs & BLOBs are now fetched on demvà to improve query performance.Single record view will now show column comments if available.The EXCEL và CSV export filenames can now include substitution variable values.The EXCEL and CSV export filenames can now include %time%, %hh%, %mi% and %ss% variables.For the “Export Results as SQL file” function you can now customize the initialization and finalization.The WITH_PLSQL hint is now supported.

Command Window enhancements

New EXPORT TABLES & EXPORT OBJECTS commands have been added. This allows you to automate frequent export jobs. You can easily build the command-line from the interactive sầu export tools.The BEAUTIFY commvà now supports wildcards.The CONNECT comm& now shows the database danh mục after typing
.The WITH_PLSquốc lộ hint is now supported.

Object Browser enhancements

The Object Browser will now show all overloaded versions of functions và procedures.You can now filter on multiple comma-separated object names (e.g. “dept%, emp%”).You can now refresh materialized views from the popup thực đơn.

File Browser enhancements

Git và Subversion support has been added.File icons now indicate the PL/Squốc lộ Developer tệp tin type.You can now filter files based on the name, form size, date, read-only status, and version control status. You can specify the filter in the options dialog:


You also can enter the filter expression directly at the top of the File Browser:


All windows shell functions are now available from the popup thực đơn.You can now create a specific PL/SQL Developer file type from the “Create File” popup menu công trình.You can now add multiple files to a project at once.

Project enhancements

Git and Subversion support has been added.File icons now indicate the PL/Squốc lộ Developer tệp tin type.


Table Definition Editor enhancements

The Index and Partition storage can now be edited, copied, & pasted directly in the grid.Support for Row Archival has been added.

Test Manager enhancements

You can now add multiple Test Script files at once.You can now drag & drop Test Script files from the File Browser.You can now enable or disable multiple items at once.

Connection List enhancements

Window icons now indicate the PL/Squốc lộ Developer window type.Connection status inhỏ moved to lớn the left for consistency.


Session Window enhancements

You can now define Session Actions that can be performed from the popup menu of the session list:


Session Actions can display feedbaông xã by writing dbms_output.

Xem thêm: Real Fixes: This App Can'T Run On Your Pc ” In Windows 10

Other enhancements

Function keys have sầu been added for “Search Bar” functions (Focus, Search, Go to lớn next, Go to previous).Substitution variable checkbox và list values can now refer khổng lồ other variable values as &variable.An “Unregister License” function has been added.


Fixes for multiple monitors with different display scaling (file selector, print dialogs, MDI window title bars, scrollbar width)Conditional sections could be displayed incorrectly in the Code ContentsDefine Connections and Select Connection tree was incorrect on a secondary display with different DPI settingsMenu items with icons from templates were too small on high dpi monitorsRibbon / Menu customization form options were not preservedEditors with a right margin and wrapping enabled did not wrap at the right marginView Stack Dump function now places the error lines in center of the editorConnection matches did not process proxy user expressions (user1
database) correctly for the application backgroundDBMS_Jobs could not be edited on Oracle19 (‘xxxx’ is not a valid date)PL/SQL Table parameters would be displayed as ‘TABLE OF TABLE’ when describing a function or procedure on Oracle18Object Browser did not show private database link under User –> Objects –> Database linksCommvà Window could execute a script from the previous directory after a CD commandComm& Window did not echo the correct path after CD with a .. or . expressionSpecifying a proxy user for the Connection of a Browser Folder did not workCompare Table Data did not always show differences when connected khổng lồ a UTF8 databaseSquốc lộ Window QBE Mode could raise “not a valid integer” errorTemplate queries were always executed in the context of the main connectionProgram Window compilation error danh sách did not always have sầu a vertical scrollbarIncorrect unused value hints could occur when using a function/procedure prefix for the variable nameCommand Window did not display result lines that were all NULLsCommvà Window SQLPLUS comm& could not connect as SYSDBAThe INSTALLDIR parameter did not work for the 64 bit mmê mẩn package, và has now been replaced with an INSTALLPATH parameterPL/SQL Beautifier & parser did not recognize the EDITIONABLE and FORCE clausesSyntax highlighting for q’strings was not always correct