Cart
Sign-In
Register
Email Address
Password
  
Don't have an account yet?

1-800-700-1000

 

Allround Automation PL/SQL DEVELOPER SINGLE USER LICENSE (PL/SQL DEV 1u)

Allround Automation
No Reviews | Add Review

Share Today!

Share

 

  
Software/Volume Licensing [?]Software/Volume Licensing  – Simple, convenient and cost-effective software purchasing solution for small, medium or large organizations that grants the legal right to run or access a software program. Volume licensing does not include any installation discs and it can only be used in conjunction with a Media Kit. Typically, one copy of Media Kit may be required and must be purchased along with the licenses. Also note that each software company has different licensing programs with different rules and minimum quantity requirements.
Allround Automation PL/SQL DEVELOPER SINGLE USER LICENSE
 
PPL/SQL Developer is an Integrated Development Environment for developing, testing, debugging and optimizing Oracle PL/SQL stored program units like packages, triggers and so on.  
  • PCM Part #: 7215545 
  • Manufacturer Part #: PL/SQL DEV 1u 
  • Platform: PC 


PL/SQL Developer is an Integrated Development Environment for developing, testing, debugging and optimizing Oracle PL/SQL stored program units like packages, triggers and so on. PL/SQL Developer features context sensitive help and database object descriptions, syntax highlighting, data querying and editing, a graphical browser, and other functions to make a developer's life easier.

The following are 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.

You can use the Query Reporter freeware tool to run your reports without PL/SQL Developer, and to run them from the command-line.

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.

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).

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.

HTML Manuals
Oracle currently supplies on-line manuals in HTML format. You can integrate these manuals into PL/SQL Developer's environment to provide context sensitive help during editing, compilation errors, and runtime errors.

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.

Installation Requirements
Macintosh Universal No
System Platform Desktop/Notebook
Packaging
Package Type License
Type of Distribution Media Electronic
Languages supported english
Licensing
License Product? Yes
License Type License Only
Program Pools Applications
Number Of Users 1
close
  View/Download Coupon

User Reviews

$180.00

"List Price" is the suggested retail price provided to us by our vendors. We make no representation that a substantial number of these products have been sold or offered for sale at the list price. Actual retail prices in your area may be substantially different, Since we sell products on a national basis, it is not possible to know if our merchandise is sold at list price in any particular location or at any particular time. "You Save" reflects the difference between our price and the vendor provided list price shown on our sites. Since the list price may be different than the actual retail price in your area, you may not actually realize a savings of this amount.
Manufacturers sometimes ask that retailers not display a price if it drops below a certain amount. The "click here to see Lowest Price" message indicates that the price of the item is so low that the manufacturer requested that it not be advertised (that is, displayed). In a brick-and-mortar store, you would probably have to ask a salesperson what the price of the product is. At PCM, by clicking on "click here to see Lowest Price" you are essentially asking to see the price, at which point we show it to you.

Save More with PCM

Add Item

Price Alert

We'll send you an email notification if this item's value drops to the price you specify.

Print
Add to Favorites
Send