Released: Aug 5, 2025

Mises à jour de 2.0

Fonctionnalités

• AI Assistant:
  • Added AI Assistant which allows you to leverage the power of the most popular AI Systems to create, modify or analyze your SQL and PL/SQL code.
    • Supply an authorization key for your AI account, after which you can immediately make use of the predefined AI Functions in Plyxon.
    • Create your own AI Functions for specific tasks.
    • Use predefined AI Functions to create, modify, finish, fix or optimize SQL or PL/SQL code.
    • Let the AI System comment, review or explain code, or you can ask general questions about code.
• Oracle Manuals Integration:
  • Oracle provides extensive documentation about its products and features in Acrobat Reader PDF format. You can configure Plyxon to make use of these manuals, either by right clicking on a word in an editor, by selecting the "Oracle Manuals" item from the "Help" button list in the application button area, or by pressing Ctrl-F1 in an editor.
• PL/SQL Beautifier:
  • Added a PL/SQL Beautifier to enforce the same coding style.
    • Set up the PL/SQL Beautifier preferences, and optionally define the coding style through the PL/SQL Beautifier rules (you can also simply adopt the default rules). After that, your PL/SQL code will automatically be beautified as you work, or it will be explicitly beautified by activating the beautifier function.
    • In the preferences you can define which PL/SQL Beautifier rules file you want to use, and you can define if sources should automatically be beautified after they are created, loaded, executed, or saved.
    • By default sources will not be automatically beautified, so that you always can explicitly choose to invoke the PL/SQL Beautifier.
• Error Help:
  • In case of an Oracle error or warning, or in case of a compilation error or warning, the help function will now take you directly to the corresponding section on the Oracle Help Center website.
• Code Highlighting:
  • The PL/SQL Editor now automatically highlights control structure keywords (begin/exception/end, if/then/else/end, loop/end etc.), local variables and parameters within a function or procedure, tables and column names within a Select, Update or Delete statement, column position within the Into list and Values list of an Insert statement, and transaction management statements (savepoint, commit, rollback etc.) within a function or procedure.
• Advanced File List Filter:
  • The File List Filter now allows you to filter by name, source contents, status (read-only/read-write), creation date, and modification date. It additionally has a history list, so that you can quickly recall previously used filter expressions.
  • Access the advanced filtering options by clicking on the list button of the filter field. This will display a popup menu with a "Filter" item for additional filtering options, a "Clear" item to clear the current filter, and a list of recently used filter that you can recall.
• Read-only Accounts:
  • You can now define that an account is limited to read-only operations which prevents you from executing commands that would modify object definitions or table data.
• Added Filter to the Account List:
  • If you are using many accounts you can now use the "Filter" field at the top of the list to quickly find an account by name.
  • Use the * and ? wildcard characters for advanced filtering.
• Added Cursor variable support:
  • You can now use cursor variables in a SQL Document and view the cursor result set after execution.
  • The result set will be displayed in a new SQL Document when double-clicking on the cursor variable output value.
  • Implicit results returned by the "dbms_sql.return_result(cursor)" procedure are also made available like this, without the need to declare or use a bind variable.
• Added Test SQL Statement function:
  • The new "Test SQL Statement" function allows you to quickly execute a select statement from a PL/SQL program.
• Other Enhancements:
  • The result set grid now has a row number column.
  • Double-clicking on an object in the Object List now invokes the Edit function (for PL/SQL Objects) or Query function (for Tables and Views).
  • Export to Excel now adds the SQL text in a separate sheet.
  • Popup menu added to compilation error list with Copy, Go to, and Help.
  • Word navigation and selection with Ctrl-Arrow and Ctrl-Shift-Arrow has been improved.
  • Improved icon colors for dark mode.
  • Load Desktop now restores editor state (top line, cursor position, and bookmarks).
  • Object List popup menu item "Copy > DBMS_Metadata DDL" added.
  • In case of an error, the SQL Document now highlights the word at the error location.
  • Improved performance and stability.

Correctifs

• Fixed issue where Object List search expressions with Unicode text did not work correctly.
• Fixed issue where Date variable output values could be displayed as "Format error".
• Fixed issue where Userid parameter did not use stored passwords from the Recent accounts.
• Fixed issue where Account > Connect in New Instance did not work correctly for a SYSDBA account.
• Fixed issue where Code Assistant size could occasionally be reset to 1 line.
• Fixed issue where queries with collection type columns could cause an error.
• Fixed issue where shortcut (Ctrl-F4) to close a document did not work.
• Fixed issue where the right margin setting in the editor showed a line in an incorrect position.