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.
修正
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.
Plyxon 1.0.2.6712025年1月30日
修正
Making a connection could cause an Access Violation on macOS 15.x if the ORACLE_HOME environment variable was not defined.