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 enhancementsThe 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:
Debugger enhancementsA variable name & value can now be copied khổng lồ the clipboard through the new “Copy variable” popup menu nhà cửa.
Editor enhancementsA 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 enhancementsYou can now display multiple result sets simultaneously và can compare them:
Command Window enhancementsNew 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 enhancementsThe 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 enhancementsGit 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:
Project enhancementsGit and Subversion support has been added.File icons now indicate the PL/Squốc lộ Developer tệp tin type.
Table Definition Editor enhancementsThe Index and Partition storage can now be edited, copied, & pasted directly in the grid.Support for Row Archival has been added.
Test Manager enhancementsYou 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 enhancementsWindow icons now indicate the PL/Squốc lộ Developer window type.Connection status inhỏ moved to lớn the left for consistency.
Session Window enhancementsYou can now define Session Actions that can be performed from the popup menu of the session list:
Xem thêm: Real Fixes: This App Can'T Run On Your Pc ” In Windows 10
Other enhancementsFunction 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.
FixesFixes 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