MyEclipse Logo
 

MyEclipse Oracle Feature Overview

Outline
download the latest MyEclipse version

help and support
 

1. Preface

This document was written using MyEclipse and Oracle 9.2.x. All screenshots are based upon the default user interface settings for MyEclipse and Windows XP. However, if you experience difficulty with the instruction of this document, please see the User Feedback section for how to provide feedback to the MyEclipse documentation team.


 

2. Requirements

Below is a list of requirements for this Tutorial:

  1. MyEclipse (see Resources for a download link)
  2. Oracle Database (see Resources for a download link)

3. Introduction

A functional overview of the different Oracle capabilites is provided below.

  • Browse, create and edit Oracle types:
    • Synonyms
    • Views
    • Sequences
    • Triggers,
    • Stored Procedures
    • Functions
    • Packages
    • Package Bodies
    • Java Procedures
    • Sessions
    • Database Links
    • Monitor (active sessions, top SQL, jobs)
    • Security (user info)
    • Instance information (system paramters, table space, etc.)
  •  Execute and test services for:
    • Stored Procedures
    • Functions
    • Packages
  • Generate metadata:
    • Extract in XML form
    • Extract in DDL form
  • Additional Details views are provided for:
    • Dependent Objects
    • Privileges
    • Status
Figure 3-1 Overview of extended Oracle Nodes supported by MyEclipse

4. Node Types & Features


4.1 Synonym




Figure 4-1 Synonym Features


4.2 View



 

Figure 4.2-1 View Features




Figure 4.2-2 View Extract DDL



Figure 4.2-3 View Extract XML


4.3 Sequence




Figure 4.3-1 Sequence Features


4.4 Package




 

Figure 4.4-1 Package Features


4.5 Package Body




 


Figure 4.5-1 Package Body Features


4.6 Function



 

Figure 4.6-1 Fuction Features


4.7 Procedure



 


Figure 4.7-1 Procedure Features


4.8 Trigger




 

Figure 4.8-1 Trigger Features


4.9 Session



Figure 4.9-1 Session Features


4.10 Java Source




Figure 4.10-1 Java Source Features


4.11 Database Link




Figure 4.11-1 Database Link Features


4.12 Monitor



Figure 4.12-1 Session Information



Figure 4.12-2 Top SQL


4.13 Security



Figure 4.13 Security Information


4.14 Instance



Figure 4.14-1 Instance Information

5. User Feedback

If you have comments or suggestions regarding this document please submit them to the MyEclipse Documentation Forum.


6. Resources