Developer Tools

The PEM client features powerful developer tools that you can use to execute and analyze complex SQL commands, manage data, and debug PL/SQL code.

• PL Debugger
• Query Tool
  • Explain Panel
  • Messages Panel
  • Notifications Panel
  • Query History Panel
  • Connection Status
  • Change connection
  • Macros
• Interpreting Graphical Query Plans
• Reviewing and Editing Data
  • View/Edit Data Filter
• Schema Diff
  • The Schema Diff Object Comparison Panel
  • Schema Diff DDL Comparison Panel
• ERD Tool
  • Toolbar
  • File Options
  • Export Options
  • Editing Options
  • Table Relationship Options
  • Utility Options
  • Zoom Options
  • Table Dialog
  • Table Node
  • The One to Many Link Dialog
  • The Many to Many Link Dialog
  • The Table Link
  • The Table Notes