1 / 8

Using Oracle SQL Developer Oracle Developers Forum, 18-03-2008

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. What is SQL Developer.

ronia
Download Presentation

Using Oracle SQL Developer Oracle Developers Forum, 18-03-2008

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using Oracle SQL DeveloperOracle Developers Forum, 18-03-2008 By Chris Roderick (AB-CO-DM)

  2. Outline • What is SQL Developer? • Interactive Demo of Setup and Features • Hints & Tips • Future of SQL Developer • Support • Questions Using Oracle SQL Developer

  3. 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. Using Oracle SQL Developer

  4. Demonstration Using Oracle SQL Developer

  5. Hints & Tips • To run Vista Aero use JDK >=1.6 or set AddVMOption -Dsun.java2d.noddraw=truein <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: • Run autotrace (SELECT_CATALOG_ROLE) • Debug PL/SQL (DEBUG_CONNECT_SESSION & DEBUG_ANY_PROCEDURE) • Run Database Admin Reports (various) Using Oracle SQL Developer

  6. Support • Built-in Help is pretty good • OTN SQL Developer Home Page: http://www.oracle.com/technology/products/database/sql_developer/ • Downloads • Extensions • Tutorials • Forum • .... Using Oracle SQL Developer

  7. 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... • Data Modelling (as per JDeveloper) • PL/SQL Profiling • Database activity reporting on AWR and ASH • ....? Using Oracle SQL Developer

  8. Questions ? Using Oracle SQL Developer

More Related