мощный PL/SQL редактор, Developer plsql Oracle Database
Дата публикации:
PRYANIK, 20.11.2016 - 12:39
PL SQL Developer
мощный PL SQL редактор, подсветка синтаксиса, справка по SQL PL/SQL, описания объектов, Code Assistant, библиотека макросов и много других
Пакет PL-SQL Developer представляет собой интегрированную среду разработки для создания, тестирования, отладки и оптимизации хранимых процедурных модулей (stored program units) на языке Oracle PL SQL, таких, как пакеты (packages), триггеры и др.
Долгое время наблюдался перенос все большей и большей части бизнес-логики на серверную часть платформы Oracle Server, поэтому программирование на языке PL/SQL стало важной частью общего процесса разработки приложений. Среда PLSQL Developer torrent ориентируется на принципы удобства в работе, повышения качества кода и продуктивности программиста, что является ключевым преимуществом при разработке приложений для платформы Oracle.
В распоряжении пользователя пакета PL SQL Developer находится контекстно-зависимая справочная система. Реализован удобный доступ к описаниям объектов БД, подсветка синтаксических конструкций, построение и редактирование запросов, графический браузер и многие другие инструменты, которые так облегчают жизнь разработчика.
PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have seen more and more business logic 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 crack focuses on ease of use, code quality and productivity, key advantages during Oracle application development.
PL SQL Developer - New Features - Built-in Version Control support for Git and Subversion - Worksets - Internal difference viewer - Program Window enhancements - Debugger enhancements - Editor enhancements - SQL Window enhancements - Command Window enhancements - Object Browser enhancements - File Browser enhancements - Project enhancements - Table Definition Editor enhancements - Test Manager enhancements - Connection List enhancements - Session Window enhancements - Other enhancements - Fixes
Enhancements in PL-SQL Developer 12.0.4 * Stability improvements * User interface preference "Switch to menu" now uses a classic menu bar * Bookmarks could disappear with Block indent/unindent * Code Assistant items were not always quoted correctly when choosing (all) * Debugger could include member function names and member procedure names when displaying object instance attribute values * Program Window did not always display compilation errors for mixed case program unit names * Describing object types with mixed case object attributes could fail * Fixed incorrect unused value hint when a record field was used in a local subprogram * Fixed empty items in toolbar configuration in the File category * Loading a previous desktop in SDI mode could show duplicate windows * XMLTYPE instances fetched on an UTF8 client could be converted to the local character set * Plug-In function IDE_SetMenuName did not work for the Ribbon and Tab, only for buttons * Object Browser Triggers folder always used the all_triggers view, regardless of the "Use DBA views" preference * PL/SQL Clipboard performance improved * Plug-In Tabs and Groups were not always named correctly * 64 bit Visual Studio Plug-Ins were not always loaded * Text Importer could break or stop screen updates * Drag & Drop table and view texts (e.g. select, insert, update) did not work correctly for mixed case column names * Insert column highlighting did not always work correctly for select lists
August 16, 2017 - Enhancements 12.0.5 Command Window would hang when opening login.sql without a connection Connections tool was missing on the View ribbon Indent and Unindent on large text selections in the SQL Window would cause a delay Added keyboard access for large report menus Clicking on a [...] cell button in the SQL Window result grid while pressing Ctrl could cause an Access Violation Right-clicking in the Beautifier Rules preview would display an empty popup ORA-28055 (the password will expire within <n> days) was not handled correctly SQL Window did not parse "with procedure ... select ..." correctly Large Data Editor could add cr/lf to a multi-line text Selecting an overloading in the Code Assistant with the left and right key did not work correctly Code Assistant and Debugger showed empty items in record descriptions with subtype fields
October 23, 2017 - Version 12.0.6 released Enhancements Stability improvements Projects with AutoConnect enabled did not always open files for the specified connection Change window type could add an incorrect Unicode BOM character to the text if file encoding preference is set to "Always UTF8" Ctrl-Home did not work on the first editor line Test Window execution would fail with ORA-01742 if the script ends with a /* */ comment Saving recovery files could lead to screen flickering in SDI mode A read-only Program Window did not reload a changed program unit when prompted Large Data Editor "Save to file" function would store ANSI CLOB data as UTF16 when connected to a Unicode database Plug-In function IDE_GetWindowObject only worked for a Program Window and SQL Window Code Assistant (all) option could be missing when using subselects Drag & Drop from the Object Browser to the work area did not work Code Assistant did not work for externally identified users in combination with a proxy account Editor popup menu "Insert Template" delay fixed for large template directories New "Scroll window into view when selected" preference added
* Find & Replace functions in did not work in a Macro * Compile referencing objects did not show all invalid objects * Selection Upper and Lower case did not work in a Macro * Export Tables in Oracle format did not work when multiple tables were selected * File > Close All could cause an Access Violation * Window List function "Close all other Windows" could cause an Access Violation * Project > Save button was not always immediately enabled when modifying project properties * SQL Window did not parse multiple statements with Q'Strings correctly * Executing a script in the Command Window with dbms_output would always display an empty line before the output * Scripts generated by Export User Objects and Export Tables did not always include headers
Welcome to the PL/SQL Developer 13.0 Beta information page. We would value your participation in this beta test and invite you to give this new version a try. If you are interested you can download the PL/SQL Developer 13.0 32 bit beta version or the PL/SQL Developer 13.0 64 bit beta version. Both are time-limited until December 31, 2018. Compatibility
The setup program will install the 13.0 beta in a separate directory from any previous release you may have installed, so that both can coexist on the same PC.
PL/SQL Developer 13.0 will store its preferences and settings in a separate location from previous releases. Preferences will be stored in directory "%APPDATA%\PLSQL Developer 13" (e.g. "C:\ Users\ <User>\ AppData\ Roaming\ PLSQL Developer 13"). Other settings such as window sizes, recently used files and so on will be stored in the registry in "HKEY_CURRENT_USER\ Software\ Allround Automations\ PL/SQL Developer 13"). When first starting PL/SQL Developer 13.0, preferences and settings will be copied over from the previous release if present.
If necessary you can install both the 32 bit and 64 bit version. They will be installed in separate directories and are separate products under "Programs and Features" in the Windows Control Panel.
All source file formats are fully compatible with previous releases, both for the 32 bit and 64 bit version.
Enhancements in PL/SQL Developer 13.0.1 * Language packs added for Brazilian, Chinese, French, German, Hungarian, Japanese, Russian and Spanish * Performance and stability improvements * Refreshing a result set after executing one of multiple statements of a SQL Window script would remove all other statements from the script * PL/SQL Beautifier did not parse q'strings correctly when not using brackets and the 2nd character is a quote (e.g. q'*'hello'*') * Regular expression popup menu had a double entry for the Tab character (\t) and no entry for the Newline character (\n) * Insert column value highlighting did not work when using a RETURNING INTO clause * Debugger preference lists "Never/Always add debug info" now also support comma and semi-colon as separator * Selecting a mixed case table column name in the Code Assistant did not add quotes * File Dialog enhancements: - Entering "." will refresh directory - Entering ".." will go up one directory - Pressing F3 will focus the Search field - Pressing F4 will focus the file edit - Pressing F5 will refresh directory - Column layout was not saved correctly for international windows versions - Entering characters in the file list did not always jump to the corresponding file - Connection option is now disabled when "Allow Multiple Connections" preference is disabled - Directory shortcuts were not displayed in the file list * Command Windows script execution performance was poor when many connections are defined * Search Bar option "Search in files" did not always work correctly * SQL Window comment directives EXCEL=<file> and CSV=<file> now also support %dbuser% and %dbname% variables * Connection List could show duplicate connections * Command Windows script execution performance improved * Function key added for "Editor: Sort Code Assistant" * Application title did not show a proxy user * Find Dialog and File Dialog could show up when switching focus to PL/SQL Developer * You could not cancel AutoRefresh for a window if the connection fails * Splash Screen now always displays on monitor where application starts * Taskbar label did not always start with the connection on Windows 7 in MDI mode * Debugger could hang when the Anonymous PL/Block of the Test Window had a compilation error * Starting PL/SQL Developer maximized on secondary monitor did not display correctly * Selection indent and unindent would take too many steps to "undo" * Compare Table Data and Compare User Objects SQL preview was not always complete * Command Window SERVEROUTPUT settings were not preserved when reconnecting * Error message after failed registration could be off-screen
hack от ZWT
» Нажмите, для открытия спойлера | Press to open the spoiler «
»» Нажмите, для закрытия спойлера | Press to close the spoiler ««
Performance and stability improvements Preferences / Logon History / Fixed Users did not work correctly when using multi byte characters Window List did not scale correctly when moved between monitors with different DPI settings Key Configuration for "Log on" functions did not work for some system locales Startup Splash screen and Connection screen now show a taskbar icon File type extension registration did not always work correctly Object names with a "+" were not automatically surrounded with double quotes. Find Dialog could disappear when switching focus from the editor Comment Selection did not handle quotes in comments correctly Plug-In function IDE_CreatePopupItem now also supports the Plan Window Could not log on when ORACLE_HOME environment variable was set to an incorrect directory Editor Column Editing did not always work correctly Editor Keyword Case was not always applied after typing parentheses Shortcuts for File / Open / New / Program Window / ... did not work Command Window BEAUTIFY <file> command did not use the current directory from the CD command Command Window cursor was not always located correctly after the prompt Connecting the PL/SQL Developer main connection from the Command Window would show "Not logged on" as feedback File Dialog and Find Dialog could incorrectly show up after unlocking Windows An error message about "GetTickCount64" could appear when starting PL/SQL Developer on Windows XP
Stability improvements Executing a select statement in the Command Window could rollback an open transaction Startup performance improvement when using a large/slow template directory Performance improvement when using many connections and connection folders Compare Table Data tool would commit every record in "update database" mode when using a commit interval Using the Auto Refresh function in the SQL Window would prompt for substitution variable values for each refresh
Stability improvements Using the Find function in the Text and XML tabs in Plan Window did not work Reloading a desktop or project would lead to too many calls to dbms_application_info.set_module() for the primary session Hyperlink navigation and declaration hints did not work for SELF.<NAME> in a type body Exporting Unicode data with a file header with non-ascii characters (e.g. in a German month name with umlauts) would cause an error when opening the export file SQL Window execute selection would execute all if the PL/SQL Beautifier option "Before compiling" was enabled for SQL Windows Displaying a package variable in the debugger from within a standalone procedure could result in "Not a variable" Debugger could not step through program unit code with a mixed case object name Test function for a mixed case program units did not generate a Test Script Debugger could not show attribute values without SELF prefix Debugger could not show mixed case variable values with a package prefix Mixed case program units were not reloaded with the Autosave Desktop option Package elements are now displayed with original case in the Object Browser Test Manager recent file list did not work Test Manager now displays a warning in case of duplicate descriptions Object Browser right-click performance improvement when many objects are displayed Debugger will now show the attribute values when holding the mouse cursor over SELF Holding the mouse cursor over a selection in the debugger will show the value of the selected expression File Browser would incorrectly show parent/child locations in subdirectories Crash recovery form did not have an icon on the taskbar Test Window Profiler tab page could display error "xxxxxxxxx is not integer value" (64 bit only) Backspace did not work correctly in text editor column editing mode Window List did not properly handle all dynamic display scaling changes Editor performance improvement when navigating text with many highlights
Stability improvements Added horizontal mouse wheel support to the editors and grids File dialogs to select a Test Set or Test Script in the Test Manager incorrectly allowed multi-select Crash recovery did not correctly restore recently used project files You could not select multiple files in the File Browser with the Shift key Long single-line exception messages could be truncated in message boxes Tree view indent could be incorrect after changing the display scale Debugger "Execute SQL" function did not show a result set for a WITH statement Execution in a Command Window did not immediately enable the Break button Recently used file list did not work correctly within the scope of a project Changing the connection of a window could affect the "Compiled" indicator of other Program Windows for that connection Command Window CONNECT command would show the connection info twice in Single Connection Mode Code Assistant could show select loop variable field list beyond the scope of the loop Test Window bind variable scan function could fail when using q'<string>' expressions Table.column highlighting did not always work within if-then-else statements x32 + x64
Stability improvements After exiting PL/SQL Developer, a plslqdev.exe process could remain Excel export functions now pass dates before Jan 1, 1900 as text to prevent conversion errors When copying and pasting a row in a SQL Window result set, line breaks would disappear View Error Stack function could truncate the stack when it is very deep Oracle Error messages longer than 1023 characters would be truncated Right Margin preference did not immediately apply to open editors Substitution variable IFEMPTY clause now supports select statements with bind variables to reference other substitution variables Objects lists did not respond to object function shortcuts that included the Enter key Cursor loop variables were not always described by the Code Assistant Connection indicator did not have the correct size after a display DPI change View stack dump function performance improved Table drag & drop function for "Insert" and "Update" would include virtual columns Hint popup would not always disappear when using Alt-Tab
» Нажмите, для открытия спойлера | Press to open the spoiler «
»» Нажмите, для закрытия спойлера | Press to close the spoiler ««
Language packs updated for 14.0 features Large Data Editor did not show in Single Record View in the SQL Window Selection > Uncomment would remove /* and */ in string constants Window List did not conform to the “Short Text” setting for Difference Viewer windows The Difference Viewer window did not always have a correct title Cut and Paste did not work in the SQL Window in Single Record View Code Assistant would display urowid parameters as “Unknown type 104” Table Definition Editor Index Column Selector would convert string expressions to lowercase Entering a value with square brackets when executing a template would interpret the square brackets as a variable Key Configuration items for File / New / Program Window were missing The Command Window BEAUTIFY <file> command did not conform to the Files / Format / Linebreaks preference The Project desktop file (project.dsk) is now portable Using the “SQL Window: Hide Editor” function would incorrectly reposition the vertical splitter The Debugger did not always show correct variable values in local subprograms Object Browser Filter “My invalid objects” would raise ORA-00918 when opening the Triggers folder Clicking on Window List items did not always work correctly after changing the display File Locations import/export functions added File Browser directory popup items added for Git Clone and Subversion Checkout Change All Lines popup menu item added to the Diagram Window Fixes for multiple monitors with different display scaling (file selector, print dialogs, MDI window title bars, scrollbar width) were not available in the 64 bit version The “Close unused connections” preference could cause delays when closing a window or when changing the main connection The Quick Access Toolbar in Full Screen mode on Windows 10 was transparent
The “Test” function on Oracle 18 and later now correctly declares %ROWTYPE parameters A startup delay could occur when the default printer was not accessible Report results could not be copied with Ctrl-C The User Defined Tools “Execute” and “Help” button did not work The Find dialog could incorrectly copy text selected in the editor Editor search hits were not always immediately visible when too far to the right Load Desktop, Crash Recovery and Load Workset will not retry failed connections PL/SQL Beautifier will now align exception declarations with variable declarations Column aliases in View DDL did not use quotes for mixed case column names File Browser and window version control status were not updated after File > Save As Template popup menu could be empty (after long time or hibernate) Reopening a Workset immediately after closing it did not show the last changes The Git status of files in subdirectories were not always up-to-date in the File Browser
Fixed an editor memory leak File > Save All did not work for unchanged database sources A floating Bookmark List could be empty after startup The Difference Viewer popup menu had incorrect menu items Selection > Uppercase / Lowercase did not interpret quotes in comments correctly The Editor Find function did not always scroll the search result into view The custom toolbar button for the Workset Apply function would be too large Ribbon group images could be blank if the main window was too small
Import Tables would truncate NVARCHAR2 column values at 4000 bytes For databases with max_string_size = extended. The Difference Viewer did not always display national characters correctly when comparing files Macro playback can now be undone as one Clicking on a Bookmark List item did not always work correctly Windows Shutdown or Sign out would not stop PL/SQL Developer when selecting “don’t save” Windows Shutdown or Sign out would ask to save modified Workset files The PL/SQL Beautifier did not format the bind variable list for an “OPEN cursor USING” statement PL/SQL Developer will now ask for translation when first run, depending on the Windows language
Note: downloading an update through Check Online Updates in version 14.0.1 did not always work. Version 14.0.1 users can download 14.0.6 here. Querying a table with LOBs or Objects on Oracle21c would raise an error Queries on Oracle21c could raise an “ORA-24444: TTC RPC (OALL) not allowed” exception PL/SQL Beautifier could add empty lines after “OPEN cursor” statement Opening the “Roles” folder in the Object Browser could display a popup message with the current username
Stability improvements Difference Viewer options button only worked with right-click Editor Object Popup submenu “Standard queries” was empty Editor Object Popup submenu now has a corresponding object image Generating a Test Script did not handle “Procedure XXXX within package YYYYYY does not exist” exceptions Generating a Test Script for a packaged procedure/function did not include the procedure/function name in the window title Drag & drop did not always work in the Window List Database Link Definition Editor for “current user” now has the password field disabled Table Definition Editor did not support invisible property for virtual columns Search List dockable tool in unpinned mode could cause errors Window connection menu now has a “Read Only” item to view or change the read only mode of the session of the window A Read Only window connection is now displayed with a lock icon SQL Window “Edit data” button now shows an error message if the connection is read only Changing the Read Only property of a Connection definition did not update the currently opened windows for that connection Shift-Click in a result grid cell did not mark a selection Program Window compilation could cause a flash in the editor With an External Difference Viewer defined, the “Reload and discard current modifications?” feature did not work properly Program Window Code Contents and PL/SQL Beautifier could not process quoted identifiers without separating blanks (e.g. procedure”Init”is…) Fixed Key configuration grammar error (spec && body) Export Key Configuration in the preferences did not work Popup menu items in Plug-Ins could be invisible File dialogs in Plug-Ins were not displayed correctly Recall Statement search filter did not work when PL/SQL Developer was not connected Explain Plan function for update and delete statements now automatically removes a RETURNING clause New Plug-Ins with svg images would not show these in popup menu To-Do List did not immediately show items when a file was opened Explain Plan Window Editor now has highlighting for parentheses and DML items Parameter “NoAppShadow” added to suppress the main application window shadow Preference name was not displayed correctly when using international characters OCI Library preference now has a file selector Connection definition property fields could be incorrectly disabled Some Plug-Ins had large images in popup menus DBMS Scheduler did not have the correct icon for Schedules Report Window Dark Styles added SQL Window “Refresh result set” function would cause a flash Workset Manager Filter field did not always have a hint Active Query Builder and plsqldoc Plug-Ins updated to the new PL/SQL Devloper 15.0 style
Stability improvements Improved performance when using Single Document Interface Object Browser and File Browser performance improvement when expanding items New styles added: Windows 11 Light & Dark, Windows 11 Polar Light & Dark, Copper Light & Dark The new Windows 11 Light & Dark styles are now used by default on Windows 11 Report Window print did not work for the Edge Browser interface Maximizing or restoring the Find Database Objects window would raise a “Component already exists” error Starting PL/SQL Developer by double-clicking a source file did not always open the file Go to Preferences > Files > Extensions > Register file types to apply this change Opening the Find tool with selected editor text would remove leading and trailing spaces from the default find text The Command Window resulting from the DBMS_Metadata > DDL function used the main connection instead of the source object connection Reload and Revert would not restore bookmarks Report “Style Library File” option added, supporting css files Macro menu items (and Tools, Reports, etc) in toolbar would not be restored after program start Docked Search list results would not jump to selected item Improved button image colors for SQL Window fetch next page, last page and post changes Search list would not always be updated when a window was closed Code Assistant scrollbar could not be dragged SQL Window result set paste with a selected row could result in column data mismatches Search Bar performance optimized for searches with many hits Session Window would not stop auto refreshing in case of error SQL Window Ctrl-F8 (execute current statement) would cause an Access Violation if PL/SQL Developer is not connected Fixed some multi-monitor High DPI issues
Performance and stability improvements Large Data Editor External tool did not work correctly if the %1 parameter was omitted and the temp path includes spaces Oracle21c JSON column data type was incorrectly presented with size as JSON(8200) Oracle21c JSON parameter data type was incorrectly presented as “Unknown type 119” Oracle21c JSON column data type support in the SQL Window and Large Data Editor when using an Oracle21c Client The plsqldoc Plug-in function “View Documentation” could cause an Access Violation Oracle HTML Manuals function would sometimes navigate to the top of the page instead of the context topic Command Window feedback updated with the latest Oracle21c SQL commands Creating a new Workset based on a previous Workset would incorrectly allow multi-select Quoted identifiers that are too long were not marked as such Adding an SQL Window to a Project could add the table of the select statement instead of the SQL Window file SQL Window and Test Window Statistics sorting would change after each run Compare User Objects / Compare Table Data: Cancelling the Target Session logon dialog would disconnect previous target session without displaying “not connected” Command Window would not always show execute status correctly when executing external files Command Window “set sqlblanklines” did not always work properly Command Window Export Tables command in “SQL Inserts” mode did not always pass the “drop” parameter Command Window Export Tables command in “PL/SQL Developer” mode did not always pass the “where” parameter Export Zip format now automatically switches to 64bit mode Saving the DBMS Output text in a SQL Window or Test Window would remove trailing spaces Editor bookmarks could be displayed at an incorrect horizontal position in the editor gutter System generated indexes are now omitted for compare operations Code Assistant did not always work for select alias for “insert into … (select …)” statements Printing CLOB text from Large Data Editor could give blank pages in dark mode Improved behavior when switching between Multiple and Single Document Interface x32-x64
Performance and stability improvements SELECT FOR UPDATE statements in the SQL Window could be rolled back if there were additional spaces or comments between FOR and UPDATE Oracle23c Boolean field datatypes were displayed as boolean(1) Oracle23c Boolean field data was displayed as T/F on an Oracle23c Client, instead of 1/0 on older clients Oracle23c Boolean column data could not be exported with the “Export Tables” tool Objects with Oracle23c Boolean attributes could not be accessed Export User Objects now takes UTF8/ANSI encoding preference into account Save text from large data editor now takes UTF8/ANSI encoding preference into account Test Window would interpret bind variables within double quotes Drag & Drop did not work correctly in the Connection List: only windows can now be moved to another connection When using an external difference viewer, Unicode characters would be converted to question marks Session Window detail queries did not support WITH FUNCTION statements Drag & Drop of a shortcut will now open the shortcut target file Performing a Find with an error in a regular expression could cause a long delay Wrapped text in result grid cells could be visually truncated Clicking on the “To-Do List” button in the Project Window will now directly take you to the To-Do Items Command Window would not spool line comments A comma in a password would not work correctly when the PL/SQL Developer desktop was reloaded Some Test Manager Edit menu items would incorrectly be enabled Export to Clipboard would not always work correctly for Unicode Opening a database source with compilation errors would not allow you to navigate to an error x32+x64