Mensys Online Shop
| Category: | Productivity - Utilities | By: | Allround Automations |
| More info: | www.allroundautomati... | ||
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 » Read more... |  |
All prices are in Euro excl. VAT (19%, for books 6%) and excl. shipping.
E-mail or call us at +31 (0)23 548 20 20 for licences, upgrades and other questions.
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.
New features for 7.1
Unicode support for the
PL/SQL editor, SQL editor, and object definitions
The
SQL and PL/SQL editors now support Unicode, so
that you can write programs and queries that
include Unicode characters. You can also use Unicode
characters in object definitions such as tables, views,
and so on.
Code folding
The PL/SQL Editor
now features code folding, which allows you to
hide pieces of PL/SQL code you are not
currently interested in, or show just the code
you are focused on. It generally gives a
better overview of complex PL/SQL programs, and makes
it easier to identify the code structure.
Split
editing
The PL/SQL Editor allows you to split
the editor into 2 parts, so that you
can view or edit 2 related code sections
in the same program.
SQL Exporter
In addition
to the CSV, XML, HTML exporters, you can
now also export query results to an SQL
file. The resulting file will contain insert statements
for the selected records.
New editor preferences
- Line number interval - display line numbers in PL/SQL and SQL Editors with 1, 5 or 10 interval, or display only the current line number.
- Show line status - Show the line status in the editor margin: yellow = changed, green = new.
- Wrap lines - Wrap long lines when they reach the right margin.
- Allow folding - Allow or disallow PL/SQL code folding.
Other enhancements
- Text Importer now has an Initializing and Finalizing script.
- Edit > Show Special Characters menu item added to show tabs, spaces, and end-of-lines.
- Command Window SPOOL command now support [APPEND|REPLACE] options.
- Help system switched to HTML Help for Windows Vista compliance.
- License management changed to one-time registration (Help > Register menu item)
- SQL Window "Show gutter" preference and popup menu added
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.
Authorization
In most development
environments you will not allow all PL/SQL Developer
functionality in all databases. For example, in development
databases you can grant all PL/SQL Developer functions,
in test databases you can grant only the
data querying/editing and object viewing functionality, and perhaps
you do not want allow PL/SQL Developer to
access your production databases at all. Through the
PL/SQL Developer authorization function you can easily define
which functions can be used by specific database
users or roles.
Plug-In extensions
The functionality of
PL/SQL Developer can be extended through Plug-Ins. We
supply Plug-Ins on the Add-ons page that you
can download without any extra costs. Plug-Ins can
be provided by Allround Automations (such as the
Version Control Plug-In or the plsqldoc Plug-In) or
by other users. If you have a programming
language that can create DLL's, you can even
write your own Plug-Ins.
Multi-threaded IDE
PL/SQL Developer
is a multi-threaded IDE. This means that you
can continue to work as SQL queries are
executing, PL/SQL programs are executing, debug sessions are
running, and so on. It also means that
the IDE will not "hang" if you make
a programming error: you can break execution or
save your work at any time.
Easy installation
No middle-ware required other than SQL*Net. No database
object installation. Just a simple one-button installation procedure
and you're ready to use it.
System requirements
PL/SQL Developer will run on Windows 95, 98,
ME, NT4, 2000, XP, 2003 and Vista. The
supported Oracle Server versions are 7.x, 8.x, 8i,
9i, 10g and 11g on any platform. To
connect to an Oracle database, PL/SQL Developer requires
a 32-bit SQL*Net, Net 8, Net 9, Net
10 or Net 11 version.