Plyxon is a brand new, lightweight, easy-to-use, multi-threaded, high-performance Oracle PL/SQL Development tool for Windows, macOS and Linux. It is a native Oracle Client tool that is easy to install and that does not require any additional third-party software.

Features

Powerful PL/SQL Editor

With its Syntax Highlighting, Object Descriptions, Code Assistant, Code Contents, Hyperlink Navigation, Macro Library and many other sophisticated features, the PL/SQL editor will even appeal to the most demanding user.

Integrated Debugger

The integrated debugger offers all features you could wish for: Step In, Step Over, Step Out, Run Until Exception, Breakpoints, View Variables, View Call Stack, and so on. You can debug any program unit without making any modification to it, including triggers and object types.

SQL Documents

The SQL Document allows you to enter any SQL statement or multiple statements and view or edit the results. You can easily recall previously executed SQL statements from a history buffer.

AI Assistant

The AI Assistant allows you to leverage the power of the most popular AI Systems to create, modify or analyze your SQL and PL/SQL code at minimal costs. All you need to do is supply an authorization key for your AI account, after which you can immediately make use of te predefined AI Functions in Plyxon. You can also create your own AI Functions for specific tasks. With the predefined AI Functions you can create, modify, finish, fix or optimize SQL or PL/SQL code. You can also let the AI System comment, review or explain code, or you can ask general questions about code.

PL/SQL Beautifier

The PL/SQL Beautifier allows you to format your SQL and PL/SQL code through a user-defined set of rules. Your code can automatically be beautified when you compile, save, or open a file. This feature will increase your coding productivity and will improve the readability of your PL/SQL code if you are working in large project teams.

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.

Object List

The Object List displays all information that is relevant to PL/SQL development. Use it to get object descriptions, to view object definitions, to create test scripts for the debugger, to enable and disable triggers and constraints, to recompile invalid objects, to query or edit tables or view data, to copy object names into an editor, and so on. The Object List additionally displays dependencies among objects, and lets you recursively expand these dependent objects (e.g. package references view, view references table, super/subtypes, and son on).

File List

If you frequently access source files and scripts from a limited set of locations (e.g. project directories, tool directories, and so on), you can use the File List for quick and easy access. Instead of opening a file selector to open or save files, you can access them directly from the Plyxon work area. From the File List you can access files and directories from user-defined locations on the local computer or on the network. You can quickly open, create, copy, move, rename, and delete files and directories here.

Account List

The Account List makes working with multiple accounts easy with a hierarchical view where you can quickly connect to a database with a specific account.

Table Definition Editor

You can view, create and modify tables without using any SQL. Just enter the information in an easy to use form, and Plyxon will generate and/or execute the appropriate SQL to create or alter the table.

Code Snippets

Plyxon’s pre-defined and user-defined Code Snippets can be a real time-saver and can help you enforce standardization. Whenever you need to insert some standard SQL or PL/SQL code into an editor, and whenever you need to create a new object from scratch, just invoke on the corresponding Code Snippet directly from the PL/SQL Editor or from the File List.