Oracle Capabilities

When data manipulation is required while developing an application, you can access many functions of your Oracle database directly.  Here you will learn about:

  • How to use Oracle features
  • Node types and features

This feature is available in MyEclipse.

1. Using Oracle Features

When developing applications in MyEclipse that require data manipulation, you have direct access to many functions of your Oracle database.

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

2. Node Types & Features

Synonym


Synonym features

View


View features


View Extract DDL


View Extract XML

Sequence


Sequence features

Package


Package features

Package Body


Package body features

Function




Function features

Procedure




Procedure features

Trigger




Trigger features

Session


Session features

Java Source


Java source features

Database Link


Database link features

Monitor


Session Information


Top SQL

Security


Security Information

Instance


Instance Information

3. Resources