Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

New Stored Object Dialog

Select the object type:

Procedure

A procedure is a sequence of executable statements that performs a particular action. Procedures can be stored in the database (where they are also executed) and reused; they are then referred to as stored procedures. Stored procedures cannot be embedded in a SQL statement.

Function

A function is a block that returns a value. Functions can be stored in the database and reused. Stored functions can be called from within a SQL statement.

Package+Body

A package is an encapsulated collection of related schema objects, including modules and other constructs, such as cursors, variables, exceptions, and records. Packages allow procedures, functions, variables, and cursors that share common or related functions to be compiled and stored as a single schema object.

  • Packages allow encapsulation of internal subroutines and variables.
  • With packages, you can specify which code is publicly available to programmers and which data should be hidden. In addition, you can implement global variables, data structures, and values; these persist for the duration of a user session.
  • Packages have both a specification and a body. The package specification declares procedures, functions, cursors, and variables.
  • The package body contains the implementation of the public procedures and functions, together with internal and private programs and variables.

Type+Body

Object types are user-defined data types, equivalent to "classes" in object-oriented languages, that may consist of composite data types or collections such as repeating groups or complex record types. Object types may be associated with member functions and procedures that are implemented in PL/SQL. These modules implement the methods of the object type.

Like packages, object types have both a specification and a body.

  • The specification lists the object's attributes and member functions.
  • The body contains the actual code for the methods.

Trigger

A trigger is a named PL/SQL unit that is stored in the database and executed in response to a specified event that occurs in the database.

TIP: For each object type, SQL Navigator provides a ready made template or "shell" to make coding easier. You can modify these templates. The template name and location is defined in the opening comments when the new object is created.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating