Jerry Held

1
(No Transcript)
2
Oracle9i JDeveloper for Database Developers and
DBAs

• Brian Fry
• Principal Product Manager
• Oracle JDeveloper
• Oracle Corporation

3
Agenda

• Database and SQL Development
• Schema Modeling and Offline Editing
• PL/SQL Development and Debugging
• Questions and Answers

4
Best IDE for the Database

• Award-winning database support
• Best Database Tool for Java
• Best Java Database Application Tool
• Best Database Access Tool

• Any JDBC database
• PL/SQL web services
• SQLPlus, iSQLPlus
• JPublisher
• interMedia
• SQLJ
• XML and XDB

• OLAP (BI Beans)
• Business Components for Java
• Connection Manager
• Database Browser
• PL/SQL IDE
• Java Stored Procedures
• Database Modeling

5
Agenda

• Database and SQL Development
• Schema Modeling and Offline Editing
• PL/SQL Development and Debugging
• Questions and Answers

6
Connection Manager

• Create and test connections with a wizard
• Store often-used connections
• Import and export connections
• Reuse connections throughout lifecycle
• Database, PL/SQL Development
• Application Development
• Deployment
• Additional connection types
• Application Server, WebDAV Server, SOAP Server,
  Oracle9i SCM Server, UDDI Registry

7
Browsing the Database

• View schema objects from the Navigator
• Tables (Indexes, Columns, Constraints, Data)
• Views
• Synonyms
• PL/SQL subprograms
• Oracle Objects
• Materialized Views (Snapshots)
• Java Resources
• User-defined filters at all levels

8
Creating Database Objects

• Create schema objects
• PL/SQL subprograms
• Tables
• Views
• Triggers

9
SQL Worksheet

• Execute any valid SQL statement
• Browse query results
• Access previous statements from SQL History
• Fetch rows incrementally

10
Tuning SQL Statements

• Get the Explain Plan for any SQL statement

11
D E M O N S T R A T I O N
Database Browser
12
Agenda

• Database and SQL Development
• Schema Modeling and Offline Editing
• PL/SQL Development and Debugging
• Questions and Answers

13
Schema Modeling

• Design-capture existing schema objects
• Visually design tables and relationships
• Generate DDL from diagram
• SQL File
• Directly to database
• Reconcile with database

14
Offline Tables

• Import objects from an existing database
• Create and edit table definitions while
  disconnected
• Generate DDL to create or alter tables
• Reconcile changes with database

15
D E M O N S T R A T I O N
Schema Modeling
16
Agenda

• Database and SQL Development
• Schema Modeling and Offline Editing
• PL/SQL Development and Debugging
• Questions and Answers

17
Editing and Compiling PL/SQL

• Comprehensive editor features
• Bookmarks
• Macros
• Code Templates
• Search and Replace
• Syntax Highlighting
• Etc
• PL/SQL Code Insight
• Synchronized Structure window
• Errors reported in Log window

18
Running PL/SQL

• Run Procedures, Functions, and Packages
• DBMS_OUTPUT
• Function return values
• OUT parameters
• Run PL/SQL dialog
• Specify run target
• Shows parameter information
• Generates editable PL/SQL block for populating
  parameters

19
Debugging PL/SQL

• Supported with Oracle8i and later
• Uses JDWP implementation starting with Oracle9i
  Release 2
• Control program execution
• Step Into, Step Over, Run to Cursor, etc
• Inspect and modify variables
• Tooltips in Code Editor
• Configure breakpoint conditions

20
PL/SQL Debugging Requirements

• Compiled with debug information
• JDeveloper Database Connections preferences
  panel
• ALTER SESSION SET PLSQL_DEBUG TRUE
• ALTER ltPROG_UNITgt COMPILE DEBUG
• Oracle8i and Oracle9i specifics
• CREATE ANY PROCEDURE (debugging other schemas)
• Oracle9i Release 2 specifics
• DEBUG ANY PROCEDUREDEBUG CONNECT SESSION
• Compiled in Interpreted (not Native) mode

21
Additional PL/SQL Debugger Features with Oracle
9.2

• Debug Java stored procedures
• Seamless debugging between server-side Java and
  PL/SQL
• Inspect elements of PL/SQL Collections (Tables,
  Records, etc)
• Remotely debug PL/SQL calls from any client

22
Remotely Debugging PL/SQL
Database Session
JDeveloper
Client Application
23
Remotely Debugging PL/SQLExplicit Calls

• Start the debugger listener in JDeveloper (Listen
  for JPDA)
• Modify the client code to attach to the debugger
  listener from the database session
• DBMS_DEBUG_JDWP.CONNECT_TCP (host, port)
• Initiate procedure call from the same database
  session, for example
• EXEC my_procedure
• Modify the client code to terminate the
  connection with the debug listener
• DBMS_DEBUG_JDWP.DISCONNECT_TCP()

24
Remotely Debugging PL/SQLImplicit Calls

• Two-tier OCI applications
• Set environment variableset ora_debug_jdwp
  host12.acme.comport4040
• OCI layer transparently calls the server-side
  PL/SQL to connect with the debugger listener
• Web mod_plsql applications
• Create a UI form to set a cookie in the browser
• Pass the hostname and port to owa_debug package
• owa_debug transparently calls the server-side
  PL/SQL to connect with the debugger listener for
  each subsequent page requested by that browser

25
D E M O N S T R A T I O N
PL/SQL Development
26
Summary

• JDeveloper is a complete development environment
  for SQL and PL/SQL in addition to Java and XML

27
A
28
(No Transcript)