PL/SQL Developer

PL/SQL Developer

USD216.00USD648.00

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 focuses on ease of use, code quality and productivity, key advantages during Oracle application development.

Clear
Add to Wishlist
Add to Wishlist
SKU: N/A Category:

Description

Major features of PL/SQL Developer:

Powerful PL/SQL Editor
With its Syntax Highlighting, SQL and PL/SQL help, Object Descriptions, Code Assistant, Compiler Hints, Refactoring, PL/SQL Beautifier, Code Contents, Code Hierarchy, Code Folding, Hyperlink Navigation, Macro Library and many other sophisticated features, the Unicode compliant editor will even appeal to the most demanding user. Information is automatically presented to you when you need it, or is at most one click away.

 

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

 

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.

 

SQL Window
The SQL Window allows you to enter any SQL statement or multiple statements and view or edit the results in a grid. The result grid supports a Query By Example mode to search specific records in a result set. You can easily recall previously executed SQL statements from a history buffer. The SQL editor provides the same powerful features as the PL/SQL Editor.

 

Command Window
To develop and execute SQL scripts you can use PL/SQL Developer’s Command Window. This window has the same look and feel as SQL*Plus, and additionally has a built-in script editor with corresponding syntax highlighting. Now you can develop your scripts without the “edit script / save it / switch to SQL*Plus / run script” cycle, and without leaving the comfortable PL/SQL Developer IDE.

 

Reports
To run reports against your application data or against the Oracle dictionary, you can use PL/SQL Developer’s built-in Report functionality. There are a number of standard reports, and you can easily create your own custom reports. These custom reports can be saved in a report file, which can in turn be included in the reports menu. This makes it very easy to run your own frequently used custom reports.

 

Diagrams
The Diagram Window allows you to create a graphical representation of a selection of objects. This way you can easily visualize (a part of) the database objects of your application or project and their relations. A diagram can be used for documentation purposes, but can also serve as a workspace. Right-clicking on an object provides access to all object functions, and double-clicking on an object will invoke the default action for the object type.

 

Projects
To organize your work you can use PL/SQL Developer’s built-in project concept. A project consists of a collection of source files, database objects, notes, and options. It allows you to work within the scope of a specific set of items, instead of a complete database or schema. This makes it easy to find the project items you need, to compile all project items, or to move a project from one location or database to another.

 

Regression Testing
For regression testing you can use PL/SQL Developer’s built-in Test Manager. You can define and run a Test Set, and quickly determine if all tests run correctly. In case of an error, the Test Manager can launch the Debugger to investigate the cause of the error. You can run Test Sets from the Command Window for automated regression testing.

 

To-Do Items
You can use To-Do Items in any SQL or PL/SQL source file to make a quick note that something needs to be done in this source file. You can access this information later from the To-Do List, either at the object level or at the project level.

 

Object Browser
This configurable tree-view 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 search for text in object sources, to drag and drop object names into an editor, and so on.
The Object Browser additionally displays dependencies among objects, and lets you recursively expand these dependant objects (e.g. package references view, view references table, super/subtypes, and son on).

 

File Browser
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 Browser for quick and easy access. Instead of opening a file selector to open or save files, you can access them directly from PL/SQL Developer’s work area. From the File Browser tree you can access files and directories from user-defined locations on the local computer or on the network. You can quickly open, save, rename, and delete files here. You can use the File Browser as a docked or floating tool.

 

Connection List
PL/SQL Developer allows you to work with multiple connections simultaneously. The dockable Connection List makes working with multiple connections easy with a hierarchical view where you can quickly open windows and tools for a connection, view which windows belong to a connection, and so on.

 

DBMS Scheduler
You can use the DBMS Scheduler tool to access the Oracle database scheduler (DBMS_SCHEDULER) provided in Oracle10g and later. The tool can be used to manage DBMS Scheduler object definitions for object types such as Jobs, Programs, Windows, and so on. It can also be used to query job run information.

 

Performance Optimizing
To optimize the performance to your SQL and PL/SQL code, you can use the PL/SQL Profiler to view timing information of each executed line of PL/SQL code (Oracle8i and later).
Furthermore you can automatically get statistics on executed SQL statements and PL/SQL programs. These statistics can include CPU usage, block I/O, record I/O, table scans, sorts, and so on.

 

Non-PL/SQL Objects
You can view, create and modify tables, sequences, synonyms, libraries, directories, jobs, queues, users and roles without using any SQL. Just enter the information in an easy to use form, and PL/SQL Developer will generate the appropriate SQL to create or alter the object.

 

Template List
PL/SQL Developer’s Template List 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 program file from scratch, just click on the corresponding template.

 

Query Builder
The graphical Query Builder makes it easy to create new select statements or modify existing ones. Just drag and drop tables and views, select columns for the field list, where clause and order by clause, join tables based on foreign key constraint definitions, and you’re done. PL/SQL Developer’s built-in Plug-In interface allows for 3rd party query builders, such as the Active Query Builder.

 

Compare User Objects
After making changes to table definitions, views, program units, and so on, it may be useful to propagate these changes to another database user, or to find out what exactly the differences are. This may be another development environment, a testing environment, or a production environment. The Compare User Objects function allows you to compare a selection of objects, to visualize the differences, and to execute or save a SQL script that will apply the necessary changes.

 

Export User Objects
To export the DDL (Data Definition Language) statements of a selection of objects of a user, you can use the Export User Objects tool. This way you can easily recreate the objects for another user, or you can save the file(s) as a backup.

 

Tools
PL/SQL Developer includes several tools to make everyday development easier. You can recompile all invalid objects, search for text in database sources, import and export tables, generate test data, import text files or ODBC data, compare table data, monitor dbms_alert and dbms_pipe events, view session information, and so on.

Brand

Allround Automation

Allround Automations products are used in a wide variety of sectors, such as financial services, e-business, pharmaceuticals, education, health, telecommunications, the military, and software companies. It provides useful tools for Oracle developers at a reasonable price, and focus investments on product development and customer support. This vision has made Allround Automations and its products a valuable asset in the Oracle development community.

Additional information

Number of user license

Single user license, 5 user license

Allround Automations Plug-ins

**Note that for the 32 bit and 64 bit versions of PL/SQL Developer you will need to download the corresponding Plug-In version. A 32 bit Plug-In will be ignored by the 64 bit version of PL/SQL Developer and vice versa.

The following Plug-Ins are developed by other PL/SQL Developer users. They are therefore not supported by Allround Automations. Questions and suggestions about these Plug-Ins can be directed to the respective authors.

 

  • Active Query Builder [Download Link: 32-bit/64-bit]
    • This a replacement for the standard Query Builder. This one is based on the Active Query Builder component by Active Database Software. It offers additional features like unions, nested joins and sub-queries.
  • Plsqldoc [Download Link: 32-bit/64-bit]
    • The plsqldoc Plug-In allows you to easily generate and view HTML documentation for functions, procedures, packages, types, tables and views. The documentation is derived from the definition and the comments of these objects, in a similar way as Javadoc for the Java programming language.
  • Version Control Interface [Download Link: 32-bit]
    • The VCS Plug-In integrates PL/SQL Developer with any Version Control System that supports Microsoft’s SCC Interface Specification. This will allow you to perform Version Control operations such as check in, check out and view differences directly from within PL/SQL Developer, without the need to switch to your Version Control software.
  • FTP File Interface [Download Link: 32-bit/64-bit]
    • The FTP File Interface Plug-In allows you to load and save files via the ftp protocol from within PL/SQL Developer. This gives you the possibility to store your files on a unix or linux server or even on the internet.
  • Customized Syntax Highlighting [Download Link: 32-bit/64-bit]
    • With this Plug-In you can add your own keywords and assign any of the available highlighting schemes to them. You can even define your own query to retrieve keywords from the database. This way you can easily add package names, table names, etc as keywords.
  • PL/SQL Wrapper Interface [Download Link: 32-bit/64-bit]
    • Oracle’s PL/SQL Wrapper is a standard command-line utility to encrypt the source code of your PL/SQL program units.

Third-Party Plug-Ins

**Note that for the 32 bit and 64 bit versions of PL/SQL Developer you will need to download the corresponding Plug-In version. A 32 bit Plug-In will be ignored by the 64 bit version of PL/SQL Developer and vice versa.

  • PL/SQL Dependency Viewer [Download Link: 32-bit/64-bit]
    • The Dependency Viewer is a flexible tool to find usages of functions, procedures, types, variables, etc. in PL/SQL source code.The “Search for Usages” dialog box can be activated from the context menu of the Object Browser and the context menu of the Program Window.
  • rrProject [Download Link: 32-bit/64-bit]
    • The rrProject Plug-In is a freeware toolset aimed to increase productivity of PL/SQL Developer users.
  • Save with “show errors” [Download Link: 32-bit]
    • This Plug-In allows you to save a file with an additional SHOW ERRORS command appended at the end, so that when your file is executed in SQL*Plus it will automatically show any compilation errors. The “File” menu is extended with a “Save with show errors as” and a “Save with show errors” menu item. For more information, see http://apps-oracle.ru/mysave-plug-in-for-plsql-developer.
  • Connection Manager [Download Link: 32-bit]
    • The Connection Manager Plug-In allows you to manage an hierarchical list of connection profiles, with or without passwords. Passwords can be encrypted with a master password. The Connection Manager can replace PL/SQL Developer’s standard logon dialog if it is started with the NoLogon parameter, and if you use the Plug-In buttons or menu items to log on.
  • Emberiza Plug-Ins
  • BAR Solutions Plug-Ins
    • On the BAR Solutions web site you can find the following Plug-Ins:
      • Comment lines
        • Use this plug-in to (un)comment lines with line comments (–). If you install this Plug-In, you will get additional menu items to comment and uncomment a selection. You can assign shortcut keys to the menus for quick access.
      • Save separate
        • Use this plug-in to save the spec and body of a package in separate files.
      • Favorites
        • Use this plug-in to keep your favorite files (scripts) handy all the time.
      • Compile current
        • Use this plug-in to compile the current tab.
      • Reconnect
        • Use this plug-in to reconnect to the database you were last connected to. For instance after a nightly shutdown of the database.
      • Shift tab
        • Use this plug-in to shift-tab through your code.
      • Toggle Read-Only
        • Use this plug-in to toggle the read-only state of your window.
      • Template
        • Use this plug-in to use templates like the way the Delphi IDE works.
  • SmartEd [Download Link: 32-bit
    • SmartEd (Smart Editor) allows you to auto-complete all keywords defined in PL/SQL Developer. After typing the first character(s) you can press TAB to complete the keyword. If multiple keyword match, a list is displayed and you can select the appropriate keyword. SmartEd also recognizes all keywords added by the Syntax Highlighting Plug-in.
  • NamedSQL [Download Link: 32-bit]
    • Allows you to easily store and retrieve frequently used code.
  • NamedSQL (DB) [Download Link: 32-bit]
    • With this Plug-In you can save frequently used SQL code in the database. It allows you to name and categorize the SQL code, and to search within these categories when you want to reuse the SQL code later.
  • FindAll [Download Link: 32-bit]
    • Displays a window with all lines in the current editor that match your search string. Specify the search string by selecting text in the editor or start FindAll and enter the search string there. Click on a matching line and the editor display is changed to show that line. Regex searches are also supported.
  • Sort [Download Link: 32-bit]
    • Select some lines in the editor and select Sort and decide whether you want case sensitive or insensitive and the selected lines are replaced with a sorted version.
  • Scale [Download Link: 32-bit]
    • This is a front-end for the ExamDiff program that comes with PL/SQL Developer.
    • You can compare the source currently displayed in the Program window to code in any other accessible Schema, or in a file on your PC.
  • CompareSource [Download Link: 32-bit]
    • This is a front-end for the ExamDiff program that comes with PL/SQL Developer.
    • You can compare the source currently displayed in the Program window to code in any other accessible Schema, or in a file on your PC.
  • Easy Bookmarks [Download Link: 32-bit]
    • Provide Borland IDE Style Bookmarks using hot keys:
      • Ctrl+Shift+# – set bookmark
      • Ctrl+# – goto bookmark
  • LBC Recall Named SQL [Download Link: 32-bit]
    • This Plug-In adds extensive store and recall options for queries. It allows access to the query history of PL/SQL Developer, and you can even use history files of other applications.
  • LBC Table Sort/Filter [Download Link: 32-bit]
    • This plug-In allows you to select sort/filter options for queries. Selections will be saved for each instance/schema.
  • Startup Options [Download Link: 32-bit]
    • With this plug-in PL/SQL Developer automatically opens files or creates new windows on startup.
  • Paste Options [Download Link: 32-bit]
    • With this Plug-In you can create multiple custom paste formats. You can add characters to the beginning or the end of the text that is pasted, replace characters and strip extra control characters.
  • Remote Command (rexec) [Download Link: 32-bit]
    • This Plug-In implements the rexec Unix shell command. This allows you to kill a server process (menu Session -> Kill server process by SID), and you can run non-interactive Unix commands in a command window.
  • User-defined Text Export [Download Link: 32-bit]
    • When you install this Plug-In you get an additional user definable text export option (next to the html, xml, csv and tsv formats). This option will allow you to save files in your preferred text format. You can define separators, quotes and escape characters. You can also export in fixed length format.
  • TNS Editor [Download Link: 32-bit]
    • A quick and easy editor for your TNSNames file. Includes Delphi source code.
  • LuaPlSql [Download Link: 32-bit/64-bit]
    • LuaPlSql is a Lua Plug-In framework for the PL/SQL Developer IDE. You can program your own Add-ons for the Lua Plug-In to extend the functionality of PL/SQL Developer. Functions in an Add-on can be added to the PL/SQL Developer menu, and can perform any kind of action: access the database, the Object Browser, the current window and editor and so on.
  • SUMSoft SVCO (Schema Version Control for Oracle) [Download Link: 32-bit]
    • The SVCO Plug-In for PL/SQL Developer gives you the possibility to use the complete SUMSoft SVCO functionality inside the PL/SQL Developer environment.
    • SUMSoft SVCO is an integrated version control solution for Oracle database server schema objects. You can track all schema objects changes direct within Oracle database. No extra version control tool is required. You can go on and use your favorite IDE for Oracle or even mix different tools. You can also integrate Schema Version Control for Oracle in your own development process.
  • Query Execution Notifier [Download Link: 32-bit/64-bit]
    • A handy little Plug-In that gives you a notification when a long running query has finished. It only shows when you have switched to another application.

System Requirement

PL/SQL Developer will run on Windows XP, 2003, 2008, Vista, Windows 7, Windows 8 and Windows 10. The supported Oracle Server versions are 7.x, 8.x, 8i, 9i, 10g, 11g, 12c, 18c, 19c and 21c on any platform.

To connect to an Oracle database, the 32 bit PL/SQL Developer version requires a 32 bit Oracle Client and the 64 bit PL/SQL Developer version requires a 64 bit Oracle Client.​​​​​​​

Reviews

There are no reviews yet.

Be the first to review “PL/SQL Developer”

Your email address will not be published. Required fields are marked *