messagekasce.blogg.se - How to use pl sql developer tool

#How to use pl sql developer tool code
#How to use pl sql developer tool windows

The BEAUTIFY command now supports wildcards.

You can easily build the command-line from the interactive export tools. This allows you to automate frequent export jobs.

New EXPORT TABLES and EXPORT OBJECTS commands have been added.

For the “Export Results as SQL file” function you can now customize the initialization and finalization.

The EXCEL and CSV export filenames can now include %time%, %hh%, %mi% and %ss% variables.

The EXCEL and CSV export filenames can now include substitution variable values.

Single record view will now show column comments if available.

CLOBs and BLOBs are now fetched on demand to improve query performance.

You can now display multiple result sets simultaneously and can compare them:.

Marked editor text is automatically copied to the search field of the Find function.

When selecting a word, all matching words will be highlighted.

#How to use pl sql developer tool code

A function key “Editor: Refresh Code Assistant” has been added, to bring the Code Assistant up to date after creating new database objects.A variable name and value can now be copied to the clipboard through the new “Copy variable” popup menu item.Performance has been improved when fetching large database sources over a slow connection.A preference option has been added to prefix filename with owner when saving a database source.Using the “Test” and “Describe” functions in the Code Contents of a Program Window now automatically selects the correct overloading.As soon as you place the cursor on a transaction statement, all related statements within a program unit will be highlighted: The Program Window now highlights transaction statements, so that you can visually recognize the code that affects a transaction.The new viewer allows you to ignore differences in case and white space as usual, but it can also ignore differences in comments.įor modified lines it will mark the exact differences within the lines. These differences can now be viewed in an internal difference viewer, instead of relying on an external tool: Several PL/SQL Developer functions allow you to compare 2 texts and display the differences. When using multiple worksets you can easily switch between them, or use the workset= command-line parameter.Īll workset-related functions are accessible from the Workset group on the File ribbon:

#How to use pl sql developer tool windows

When a workset is reopened later, windows will be restored exactly like they were previously used.

After finalizing your work you can apply the workset, so that changes to the files and database objects are permanently saved.Ī workset holds the window contents, sizes and positions. Changes made to these windows are preserved when closing and reopening PL/SQL Developer, even if you have not explicitly saved or compiled these changes. WorksetsĪ workset is a set of Program Windows, SQL Windows, Test Windows, Command Windows, Report Windows and Diagram Windows that you are working on. In the screenshots above “GIT Extensions” has been used. In the File Browser and in a Project you can right-click on an item to perform a version control operation:įor these file control operations PL/SQL Developer relies on a 3rd party shell extension that must be installed on your system. Version control operations can be performed directly in a window by clicking on the version control status icon: 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. 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. Built-in Version Control support for Git and Subversion