ORACLE IDE

Table of Contents TOAD PL/SQL Developper Install With thick client without thick client (v6 only) Package in file SQL Developer Configuration file Package in file Arbori

TOAD

PL/SQL Developper

Install

With thick client

without thick client (v6 only)

Add path to tnsnames.ora in environment variable TNS_ADMIN

Package in file

Support specs and body in a single file

SQL Developer

Configuration file

In brief:

• is in home folder, or specified through IDE_USER_DIR environment variable
• preferences : <CONFIGURATION_ROOT>\system<VERSION>\o.sqldeveloper\product-preferences.xml
• formating options <CONFIGURATION_ROOT>\system<VERSION>\o.sqldeveloper\formatterOptions.xml
• formating rules <CONFIGURATION_ROOT>\system<VERSION>\o.sqldeveloper\format.arbori
• extensions load rules <CONFIGURATION_ROOT>\system<VERSION>\ide-extension-prefs.xml

Package in file

Doesn't support specs and body in a single file

Arbori

Hello World

leaking_cursor:
[cursor_decl) cursor_d
;