PL/SQL Enterprise Workbench

The Professional Oracle Database Plugin for the Eclipse IDE.

Enhance productivity, performance, and connectivity for Java developers working with Oracle Database, while simplifying development.

PL/SQL Workbench Enterprise Perspective.

The Workbench Perspective in the PL/SQL Enterprise Workbench organizes database resources to streamline PL/SQL development. It offers content assistance, syntax highlighting, error markers, and hyperlinks for faster editing and navigation. The Outline view improves code browsing, and configurable warnings and error displays help maintain code quality. Eclipse IDE source control (SCM) integration supports collaboration and versioning.

Working with SQL Commands

  • Execute SQL commands in a temporary SQL Worksheet or from a script file.
  • Use semantic code completion with detailed type and comment information for tables and columns.
  • Organize SQL script files in your file system.
  • Run SQL scripts all at once or step by step for more granular control.

Using SQL Scripts

In the PL/SQL Enterprise Workbench, you can organize these scripts in your file system and execute them either all at once or step-by-step. This helps streamline repetitive tasks, ensures consistency, and makes it easier to manage and share database operations among team members.

Develop PL/SQL Code

PL/SQL development is improved in the PL/SQL Enterprise Workbench by providing features such as content assistance, syntax highlighting, failure markers, and hyperlinks, making code writing and navigation easier. The outline view helps you quickly move through your code, while configurable warning levels and error displays enhance code quality. Integration with Eclipse IDE's SCM supports team collaboration and version control, streamlining the development process.

Xross Technology Integration

In typical real-world, data-intensive applications, PL/SQL can process data 2× to 10× faster than Java. In cases where Java processing requires many database round trips, the performance gain can increase to as much as 100×. For workloads with many consecutive read and write operations, bundling requests improves performance and simplify development and maintenance.

Cross-technology integration between PL/SQL and Java allows developers to combine the strengths of both languages. PL/SQL handles complex database logic efficiently, while Java provides robust application features and connectivity. This integration enables:

  • Direct, high-performance access to PL/SQL procedures from Java via Oracle JDBC Extensions.
  • Simplified data exchange and business logic implementation.
  • Automated code generation for seamless connectivity.
  • Extensive support for complex Oracle data types beyond what generic libraries (e.g., Hibernate, TopLink) typically use.
  • Maven support for CI/CD and modern development workflows.