Tool for Oracle Application Development

1
Tool forOracleApplicationDevelopment
2
Contents

• Toad tools (general overview)
• Options settings
• Editor options
• Loose ends

3
TOAD Tools

• Formatter Plus (option)
• Debugger (option)
• DBA (option)
• SQL Monitor
• SQL Modeler
• ER Diagram tool
• Compare Data tool
• Code Wrapper (wrapped PL/SQL)

• SQL Editor
• Schema Browser
• Procedure Editor
• Session Browser
• Master-Detail Browser
• SGA Trace Optimization tool
• TKProf Interface
• Java Manager (load/unload java in DB)

4
Options Settings
5
(Un)available Options
6
Options Settings
Immediate Edit default set off.
7
Options Settings
8
Options Settings
9
Options Settings
10
Options Settings
11
Editor Options
12
Editor Options
When displaying an SQL Editor window or Procedure
Editor window, from the Edit menu, select Editor
Options Or Right-click and select Editor
Options. You can set Printing options, Display
options, Control options, General options, Syntax
Highlighting options, Key Assignments, Auto
Replace substitutions, and Code Templates in this
dialog. There are 5 tabs in the Editor Options
dialog.
13
Editor Options
Set to whatever you like Color, Case,
14
Editor Options
Add shut-cuts for long object names or code
fragments
bv. dopl dbms_output.put_line auto replace
key (
15
Editor Options
16
Loose ends
17
Loose ends

• Profiler - code quality control in Procedure
  Editor.
• Describe F4 describe underlying object in
  most Editors.
• Extended copy-paste columns etc.
• Product comparison http//www.orafaq.com/tools/c
  omparison.htm