Transcript Using Oracle SQL Developer

European Organization For Nuclear Research
Using Oracle SQL Developer
Oracle Developers Forum, 18-03-2008
By Chris Roderick (AB-CO-DM)
Outline
 What is SQL Developer?
 Interactive Demo of Setup and Features
 Hints & Tips
 Future of SQL Developer
 Support
 Questions
18-03-2008
Using Oracle SQL Developer
2
What is SQL Developer
 Lightweight tool from Oracle for database development
 Free of charge!
 Implemented in Java, based on JDeveloper framework
 Runs on Windows, Linux, and Mac OSX
 Can connect to Oracle >=9.2.0.1 + other databases
 First released as project Raptor at start of 2006
 First production release in February 2006
 Current production release is 1.2.1 (August 2007)
 Version 1.5 Early Adopter release 2 is available since mid February.
18-03-2008
Using Oracle SQL Developer
3
Demonstration
18-03-2008
Using Oracle SQL Developer
4
Hints & Tips
 To run Vista Aero use JDK >=1.6 or set
AddVMOption -Dsun.java2d.noddraw=true
in <installdir>/sqldeveloper/bin/sqldeveloper.conf
 To enable uses of network aliases, add TNS_ADMIN
environment variable pointing to tnsnames.ora 
Don’t use: currently too slow and problematic
 jdbc:oracle:thin:@(<connection description from
tnsnames.ora>)
 Unload unnecessary extensions e.g. Migration Workbench
 Make sure you have suitable roles and privileges to:



18-03-2008
Run autotrace (SELECT_CATALOG_ROLE)
Debug PL/SQL (DEBUG_CONNECT_SESSION &
DEBUG_ANY_PROCEDURE)
Run Database Admin Reports (various)
Using Oracle SQL Developer
5
Support
 Built-in Help is pretty good
 OTN SQL Developer Home Page:
http://www.oracle.com/technology/products/database/sql_developer/





18-03-2008
Downloads
Extensions
Tutorials
Forum
....
Using Oracle SQL Developer
6
Future
 Version 1.5 Production imminent:







SQL Templates
SQL Trace File parsing and analysis
Super Code Formatter
Improved PL/SQL editing
Improved Export and Schema diff functionality
Increased object navigation (jobs, Streams, Java)
Possibly CVS integration
 After that...




18-03-2008
Data Modelling (as per JDeveloper)
PL/SQL Profiling
Database activity reporting on AWR and ASH
....?
Using Oracle SQL Developer
7
Questions ?
18-03-2008
Using Oracle SQL Developer
8