Help topic not found.  Check the online help index for related topics.


DISABLE (logging) command

  Examples	   Related Topics 	  Alphabetic List

Description	Suspends logging to the current log file.

Syntax

DISABLE LOGGING

Comments	DISABLE has no effect on logging if no log file has been specified (via the LOG command) or if logging is already disabled.

You can enable disabled logging by using the ENABLE command.


DISABLE (logging) command example

  Related Topics 	  All Examples

The following command temporarily suspends logging:

.DISABLE LOG


ENABLE (logging) command

  Examples	   Related Topics 	  Alphabetic List

Description	Resumes logging to the current log file.

Syntax

ENABLE LOGGING

Comments	ENABLE has no effect if no log file has been specified via the LOG command, or if logging is already enabled.

You can temporarily disable logging with the DISABLE command.


ENABLE (logging) command example

  Related Topics 	  All Examples

The following command resumes logging after it has been suspended:

.ENABLE LOG


LOG command

  Examples	   Related Topics 	  Alphabetic List

Description	Saves a transcript of Interpreter input and output to the specified log file.

Syntax

LOG FILE [directory]name[extension]
    [APPEND]
    [ENABLED | DISABLED]
    [OFF]

Keywords and Values

FILE name	Specifies the log file name and, optionally, the directory path and file extension.
APPEND	Indicates that log output should be appended to the specified file; otherwise, the file is overwritten.
ENABLED or DISABLED	Specify whether logging is initially enabled or disabled, respectively.  The default is ENABLED.
OFF	Terminates logging and saves the log file.
Comments	If unspecified, the log file extension defaults to .log.  The syntax of directory is operating system-specific.  For more information about syntax, see the Oracle product documentation for your operating system.

If the specified log file does not exist, a new file is created in the specified directory.  If no directory path is specified, the log file is created in the current directory.

You can temporarily disable logging and then enable it again using the DISABLE and ENABLE commands, respectively.


LOG command examples

  Related Topics 	  All Examples

The following command begins logging Interpreter input and output in the file debug.log in the current directory:

.LOG FILE debug

The following command terminates logging and saves the log file:

.LOG OFF


DELETE (load path) command

  Examples	   Related Topics 	  Alphabetic List

Description	Resets the load path to contain no elements.

Syntax

DELETE LOADPATH


DELETE (load path) command example

  Related Topics 	  All Examples

The following command clears the load path of all entries:

.DELETE LOADPATH


DESCRIBE (load path) command

  Examples	   Related Topics 	  Alphabetic List

Description	Displays the current load path.

Syntax

DESCRIBE LOADPATH


DESCRIBE (load path) command example

  Related Topics 	  All Examples

The following command displays all entries in the current load path:

.DESCRIBE LOADPATH


INSERT (load path) command

  Examples	   Related Topics 	  Alphabetic List

Description	Inserts directories into the load path.

Syntax

INSERT LOADPATH
       {DIRECTORY path[, path...] | CURRENTDIR}
       [BEFORE | AFTER]

Keywords and Values

LOADPATH	Specifies the current load path.
DIRECTORY path	Specifies one or more directory paths.
CURRENTDIR	Specifies the current directory path.
BEFORE or AFTER	Specifies whether the directories should be inserted before or after the existing directories in the load path, respectively.  The default is AFTER.
Comments	The syntax of path is operating system-specific.  For more information about syntax, see the Oracle product documentation for your operating system.


INSERT (load path) command example

  Related Topics 	  All Examples

In UNIX, the following command appends the directory /usr/plsql to the load path:

.INSERT LOADPATH DIRECTORY /usr/plsql


DESCRIBE (locals) command

  Examples	   Related Topics 	  Alphabetic List

Description	Displays the name, type, and value of a variable or parameter that is local to the current scope location.

Syntax

DESCRIBE LOCAL name

DESCRIBE PARAMETER name

DESCRIBE VARIABLE  name

Keywords and Values

LOCAL name	Specifies a parameter or variable local to the current scope location.
PARAMETER name	Specifies a parameter local to the current scope location.
VARIABLE name	Specifies a variable local to the current scope location.


DESCRIBE (locals) command examples

  Related Topics 	  All Examples

The following command displays information about the parameter p1:

.DESCRIBE PARAM p1

The following command displays information about the local variable sal:

.DESCRIBE LOCAL sal


GO command

  Examples	   Related Topics 	  Alphabetic List

Description	Resumes program execution indefinitely, after a breakpoint or debug trigger.

Syntax

GO

Comments	GO resumes program execution until the currently executing thread of execution either terminates or is interrupted by a debug action.


GO command example

  Related Topics 	  All Examples

The following command resumes program execution:

.GO


RESET command

  Examples	   Related Topics 	  Alphabetic List

Description	Returns control to an outer debug level without continuing execution in the current debug level.

Syntax

RESET LEVEL number

Keywords and Values

LEVEL number	Specifies an outer debug level.
Comments	RESET effectively aborts execution at the current and possibly higher debug levels.

You can perform a relative reset by supplying a negative value for LEVEL number.  Invoking RESET with no options always returns to top level.


RESET command examples

  Related Topics 	  All Examples

The following command resets to the previous debug level:

.RESET LEVEL -1

The following command resets to the top level:

.RESET


SET (scope) command

  Examples	   Related Topics 	  Alphabetic List

Description	Changes the current scope location to a specified frame of the call stack.  The current scope location affects how local variable references are treated in the Interpreter.

Syntax

SET SCOPE FRAME number

SET SCOPE UP [COUNT number]

SET SCOPE DOWN [COUNT number]

SET SCOPE TOP

SET SCOPE BOTTOM

SET SCOPE PROGRAMUNIT name

SET SCOPE PACKAGE name

SET SCOPE SUBPROGRAM name

SET SCOPE PROCEDURE name

SET SCOPE FUNCTION name

Keywords and Values

FRAME number	Specifies a frame by number.
UP	Specifies relative motion toward the top of the stack.
DOWN	Specifies relative motion toward the bottom of the stack.
COUNT number	Specifies a repeat count in the specified direction (UP or DOWN).  The default is one.
TOP	Specifies the top frame in the call stack.
BOTTOM	Specifies the bottom frame in the call stack.
PROGRAMUNIT name	Specifies a program unit.
PACKAGE name	Specifies a package.
SUBPROGRAM name	Specifies a subprogram.
PROCEDURE name	Specifies a procedure.
FUNCTION name	Specifies a function.
Comments	Frames are numbered from 0 (top frame) to n (bottom frame).


SET command examples

  Related Topics 	  All Examples

The following command moves up one stack frame:

.SET SCOPE UP

The following command moves down two frames:

.SET SCOPE DOWN COUNT 2

The following command moves to the frame associated with the function func1:

.SET SCOPE FUNCTION func1

The following command moves to the top of the stack:

.SET SCOPE TOP

The following command moves to the fifth frame:

.SET SCOPE FRAME 5


SHOW (call stack) command

  Examples	   Related Topics 	  Alphabetic List

Description	Lists the frames on the current call stack.

Syntax

SHOW STACK

SHOW SCOPE

Keywords and Values

STACK	Lists the program unit name and line number for every frame on the call stack.
SCOPE	Lists the frames from the top of the call stack down to the frame containing the current scope location.


SHOW (call stack) command example

  Related Topics 	  All Examples

The following command lists the current call stack:

.SHOW STACK


STEP command

  Examples	   Related Topics 	  Alphabetic List

Description	Advances execution of an interrupted program unit.

Syntax

STEP INTO

STEP OVER

STEP OUT

STEP TO PROGRAMUNIT name [LINE number]

STEP TO PACKAGE name [LINE number]

STEP TO SUBPROGRAM name [LINE number]

STEP TO PROCEDURE name [LINE number]

STEP TO FUNCTION name [LINE number]

STEP TO ACTION number

STEP TO BREAKPOINT number

STEP TO TRIGGER number

STEP TO . [LINE number]

STEP COUNT number

Keywords and Values

INTO	Enables stepping into subprogram calls.  This is the default if no keywords are specified.
OVER	Prevents stepping into a called subprogram body.
OUT	Resumes execution until the current subprogram has returned.
TO ...	Continues execution until the specified source location is reached.  Using the TO option is analogous to setting a temporary breakpoint at the specified location.
PROGRAMUNIT name	Specifies a program unit.
PACKAGE name	Specifies a package.
SUBPROGRAM name	Specifies a subprogram.
PROCEDURE name	Specifies a procedure.
FUNCTION name	Specifies a function.
ACTION number	Specifies a debug action (breakpoint or trigger).
BREAKPOINT number	Specifies a breakpoint.
TRIGGER number	Specifies a trigger.
.	Specifies the current source location.
LINE number	Specifies the line of the program unit.
COUNT number	Dictates how many times the STEP command (as qualified by the other options) is repeated.  The default is 1.
Comments	Control returns to the current debug level after the specified set of statements have been executed.


STEP command examples

  Related Topics 	  All Examples

The following command resumes execution until the first breakpoint is reached:

.STEP TO BREAK 1

The following command resumes execution for five lines:

.STEP COUNT 5


BREAK command

  Examples	   Related Topics 	  Alphabetic List

Description	Establishes a breakpoint at the specified source line within a program unit.

Syntax

BREAK {[USER schema] PROGRAMUNIT name | PROGRAMUNIT [schema.]name}
      [LINE number]
      [ENABLED | DISABLED]
      [TRIGGER plsql-block]

BREAK {USER schema PACKAGE name | PACKAGE schema.name}
      [LINE number]
      [ENABLED | DISABLED]
      [TRIGGER plsql-block]

BREAK {USER schema SUBPROGRAM name | SUBPROGRAM schema.name}
      [LINE number]
      [ENABLED | DISABLED]
      [TRIGGER plsql-block]

BREAK {USER schema PROCEDURE name | PROCEDURE schema.name}
      [LINE number]
      [ENABLED | DISABLED]
      [TRIGGER plsql-block]

BREAK {USER schema FUNCTION name | FUNCTION schema.name}
      [LINE number]
      [ENABLED | DISABLED]
      [TRIGGER plsql-block]

BREAK ACTION number
      [LINE number]
      [ENABLED | DISABLED]
      [TRIGGER plsql-block]

BREAK BREAKPOINT number
      [LINE number]
      [ENABLED | DISABLED]
      [TRIGGER plsql-block]

BREAK .
      [ENABLED | DISABLED]
      [TRIGGER plsql-block]

BREAK PC
      [ENABLED | DISABLED]
      [TRIGGER plsql-block]

BREAK SCOPE
      [ENABLED | DISABLED]
      [TRIGGER plsql-block]

Keywords and Values

USER schema	Specifies a schema name in the database where the stored program unit is located.
PROGRAMUNIT name	Specifies a program unit body.
PACKAGE name	Specifies a package body.
SUBPROGRAM name	Specifies a subprogram body.
PROCEDURE name	Specifies a procedure body.
FUNCTION name	Specifies a function body.
ACTION number	Specifies a debug action (breakpoint or trigger).
BREAKPOINT number	Specifies a breakpoint.
.	Specifies the current source location.  This is the default.
PC	Specifies the current execution location.
SCOPE	Specifies the current scope location.
LINE number	Specifies the line in a program unit at which to establish the breakpoint.
ENABLED or DISABLED	Specifies whether or not the breakpoint is initially enabled or disabled.  The default is ENABLED.
TRIGGER  pl/sql-block	Defines a PL/SQL trigger for the breakpoint.  The trigger fires each time the breakpoint is reached.
Note	If supplied, the TRIGGER keyword must appear as the last command option.

Comments	BREAK may operate only on executable source lines.

Trigger blocks may span multiple input lines.  As is the case when entering PL/SQL constructs elsewhere in the Interpreter, no line continuation characters are required when entering the trigger body (nor are they allowed).

If you wish to interrupt your program conditionally, you should use the TRIGGER command in conjunction with the DEBUG.BREAK exception.

If the statement is reached while running PL/SQL, Procedure Builder suspends execution just before the statement is executed, and passes control to the Interpreter.  At this point, you can inspect and even modify program state using a variety of Procedure Builder functions.

Once satisfied, you can resume execution with the GO or STEP commands.  Alternatively, you can abort execution using the RESET command.


BREAK command examples

  Related Topics 	  All Examples

The following command sets a breakpoint at the current source location:

.BREAK .

The following command sets a breakpoint at the second line of the procedure named my_proc:

.BREAK PROCEDURE my_proc LINE 2

The following command sets a breakpoint at the tenth line of my_proc that shows all of the local variables and their values whenever the breakpoint is entered:

.BREAK PROC my_proc LINE 10 TRIGGER
  debug.interpret('.SHOW LOCALS')

The following command sets a breakpoint at line twelve of the program unit that contains debug action number four:

.BREAK ACTION 4 LINE 12

The following command sets a breakpoint at the current source location in a server-side program unit my_proc from the schema owned by user scott:

.BREAK USER scott PROC my_proc

or

.BREAK PROC scott.my_proc


DELETE (debug actions) command

  Examples	   Related Topics 	  Alphabetic List

Description	Deletes one or more debug actions.

Syntax

DELETE ACTION number [, number...]

DELETE BREAKPOINT number [, number...]

DELETE TRIGGER number [, number...]

Keywords and Values

ACTION number	Specifies one or more debug actions (breakpoint or trigger), by number.
BREAKPOINT number	Specifies one or more breakpoints, by number.
TRIGGER number	Specifies one or more debug triggers, by number.
Comments	This command permanently removes one or more debug actions.  If you wish to temporarily remove a debug action, use the DISABLE command instead.


DELETE (debug actions) command example

  Related Topics 	  All Examples

The following command deletes debug actions two and three:

.DELETE ACTION 2,3


DESCRIBE (debug actions) command

  Examples	   Related Topics 	  Alphabetic List

Description	Displays detailed information about the specified debug action.

Syntax

DESCRIBE ACTION number

DESCRIBE BREAKPOINT number

DESCRIBE TRIGGER number

Keywords and Values

ACTION number	Specifies a debug action (a breakpoint or a trigger).
BREAKPOINT number	Specifies a breakpoint.
TRIGGER number	Specifies a trigger.
Comments	The information displayed for a debug action includes its ID, the source location with which it is associated, and whether or not it is enabled.


DESCRIBE (debug actions) command examples

  Related Topics 	  All Examples

The following command displays information about breakpoint number two:

.DESCRIBE BREAK 2

The following command displays information about debug action number three:

.DESCRIBE ACTION 3


DISABLE (debug actions) command

  Examples	   Related Topics 	  Alphabetic List

Description	Removes one or more debug actions temporarily.

Syntax

DISABLE ACTION number [, number...]

DISABLE BREAKPOINT number [, number...]

DISABLE TRIGGER number [, number...]

Keywords and Values

ACTION number	Specifies one or more debug actions (breakpoints and triggers).
BREAKPOINT number	Specifies one or more breakpoints.
TRIGGER number	Specifies one or more triggers.
Comments	DISABLE has no effect on debug actions that are already disabled.  You can restore disabled debug actions using the ENABLE command.


DISABLE (debug actions) command examples

  Related Topics 	  All Examples

The following command disables breakpoint number two:

.DISABLE BREAK 2

The following command disables debug action number three:

.DISABLE ACTION 3


ENABLE (debug actions) command

  Examples	   Related Topics 	  Alphabetic List

Description	Reactivates disabled debug actions.

Syntax

ENABLE ACTION number [, number...]

ENABLE BREAKPOINT number [, number...]

ENABLE TRIGGER number [, number...]

Keywords and Values

ACTION number	Specifies a debug action.
BREAKPOINT number	Specifies a breakpoint.
TRIGGER number	Specifies a trigger.
Comments	ENABLE has no effect on debug actions that are already enabled.  To temporarily disable a debug action, use the DISABLE command.


ENABLE (debug actions) command examples

  Related Topics 	  All Examples

The following command enables breakpoint number two, which was previously disabled:

.ENABLE BREAK 2

The following command enables debug action number one:

.ENABLE ACTION 1


LIST (debug actions) command

  Examples	   Related Topics 	  Alphabetic List

Description	Displays the program unit source text to which the specified debug action is attached.

Syntax

LIST ACTION number

LIST BREAKPOINT number

LIST TRIGGER number

Keywords and Values

ACTION number	Specifies a debug action (breakpoint or trigger).
BREAKPOINT number	Specifies a breakpoint.
TRIGGER number	Specifies a trigger.
Comments	LIST displays the text associated with the specified debug action in the Source pane of the Interpreter.  The line on which the specified debug action appears becomes the current source location.


LIST (debug actions) command examples

  Related Topics 	  All Examples

The following command displays breakpoint number one and sets the source location:

.LIST BREAK 1

The following command displays debug action number three and sets the current source location:

.LIST ACTION 3


SHOW (debug actions) command

  Examples	   Related Topics 	  Alphabetic List

Description	Enumerates the debug actions that are currently defined in the development session.

Syntax

SHOW ACTION

SHOW BREAKPOINTS

SHOW TRIGGERS

Keywords and Values

ACTION	Specifies all debug actions.
BREAKPOINTS	Specifies all breakpoints.
TRIGGERS	Specifies all triggers.


SHOW (debug actions) command example

  Related Topics 	  All Examples

The following command lists all of the breakpoints that are currently set:

.SHOW BREAKPOINTS


TRIGGER command

  Examples	   Related Topics 	  Alphabetic List

Description	Creates a debug trigger, which is a PL/SQL block associated with the specified source location.

Syntax

TRIGGER {[USER schema] PROGRAMUNIT name | PROGRAMUNIT [schema.]name}
         [LINE number]
         [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER {USER schema PACKAGE name | PACKAGE schema.name}
        [LINE number]
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER {USER schema SUBPROGRAM name | SUBPROGRAM schema.name}
        [LINE number]
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER {USER schema PROCEDURE name | PROCEDURE schema.name}
        [LINE number]
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER {USER schema FUNCTION name | FUNCTION schema.name}
        [LINE number]
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER ACTION number [LINE number]
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER BREAKPOINT number [LINE number]
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER TRIGGER number [LINE number]
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER .
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER PC
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER SCOPE
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER DEBUG
        [ENABLED | DISABLED]
        [IS plsql-block]

TRIGGER *
        [ENABLED | DISABLED]
        [IS plsql-block]

Keywords and Values

USER schema	Specifies a schema name in the database where the stored program unit is located.
PROGRAMUNIT name	Specifies a program unit.
PACKAGE name	Specifies a package.
SUBPROGRAM name	Specifies a subprogram.
PROCEDURE name	Specifies a procedure.
FUNCTION name	Specifies a function.
ACTION number	Specifies a debug action (breakpoint or trigger).
BREAKPOINT number	Specifies a breakpoint.
TRIGGER number	Specifies a trigger.
LINE number	Specifies the line of the program unit where the trigger should be located.
.	Specifies the current source location.
PC	Specifies the current execution location.
SCOPE	Specifies the current scope location.
DEBUG	Specifies entry into the debugger (i.e., when program execution is suspended due to a breakpoint, program stepping, etc.).
*	Specifies every PL/SQL source line.  Thus, placing a trigger on * will cause the specified block to be evaluated just prior to executing every PL/SQL source line.
ENABLED or DISABLED	Dictates whether the trigger is initially enabled or disabled.  The default is ENABLED.
IS pl/sql-block	Defines the body of the trigger.
Note: IS must appear as the last command option.

Comments	Procedure Builder executes the trigger just before the program reaches the specified location.  The trigger block may span multiple input lines.  As is the case when entering PL/SQL constructs elsewhere in the Interpreter, no line continuation characters are required when entering the trigger body (nor are they allowed).

TRIGGER is especially handy for creating conditional breakpoints.  This is done by raising the exception DEBUG.BREAK from within the arbitrarily complex control logic of the trigger body.  The exception is trapped by the debugger, which interrupts program execution and passes control to the Interpreter as if a breakpoint had been entered at the trigger location.


TRIGGER command examples

  Related Topics 	  All Examples

The following trigger establishes a conditional breakpoint on line ten of my_proc that is only reached if the local NUMBER variable `i' exceeds 100:

.TRIGGER PROC my_proc LINE 10 IS
IF DEBUG.GETN('i') > 100 THEN
  RAISE DEBUG.BREAK;
END IF;

Triggers can also be used to trace program execution.  The following trigger lists every source statement as it is executed:

.TRIGGER * IS debug.interpret('LIST PC');

The following command sets a trigger at line 8 in a server-side program unit my_proc from the schema owned by user scott:

.TRIGGER USER scott PROC my_proc LINE 8

or

.TRIGGER PROC scott.my_proc LINE 8


CONNECT command

  Examples	   Related Topics 	  Alphabetic List

Description	Establishes a database connection.  This command is valid only when Procedure Builder is invoked as a standalone session.

Syntax

CONNECT DB [username/password@ |
           network_device: |
           datasource_node: |
           datasource_name]
         [SILENT]

Keywords and Values

username/password@	Indicates a valid user name and password for the datasource to which you wish to connect.  The '@' symbol must precede the remaining database location specifiers.
network_device:	Specifies the networking device driver used to connect to the remote database.
datasource_node:	Specifies the network node of the remote datasource to which you wish to connect.
datasource_name	Specifies the name of the remote or local datasource to which you wish to connect.
SILENT	Optionally suppresses the status messages issued by the Interpreter.
Note  If you wish to connect to an ODBC datasource, use the following syntax:

username/password@ODBC:datasource[:dbname]

If dbname is not specified, the current database for the ODBC connection is used.


CONNECT command examples

  Related Topics 	  All Examples

The following command would connect you to the remote "inventory" database on the "boston" network node using the TCP/IP device driver.

.CONNECT DB scott/tiger@t:boston:inventory

If the "inventory" database were a local database, the following command would connect you:

.CONNECT DB scott/tiger@inventory


DESCRIBE (tables and views) command

  Examples	   Related Topics 	  Alphabetic List

Description	Displays detailed information about database tables and views.

Syntax

DESCRIBE TABLE name

DESCRIBE VIEW name

Keywords and Values

TABLE name	Specifies a table in the current database.
VIEW name	Specifies a view in the current database.
Comments	The information displayed for tables and views includes the columns and their types.


DESCRIBE (tables and views) command examples

  Related Topics 	  All Examples

The following command displays information about the EMP table:

.DESCRIBE TABLE emp

The following command displays information about the view named ASSOCIATE:

.DESC V associate


DISCONNECT command

  Related Topics 	  Alphabetic List

Description	Disconnects you from the database to which you are currently connected.  This command is valid only when Procedure Builder is invoked as a standalone session.

Syntax

DISCONNECT


GRANT command (Database commands)

  Examples	   Related Topics 	  Alphabetic List

Description	Grants a user access to a library stored in the database.

Syntax

GRANT LIBRARY name USER name

Keywords and Values

LIBRARY name	Specifies the library.
USER name	Specifies a user name.
Comments	You can specify any single valid user name, or PUBLIC (all users).


GRANT command example (Database commands)

  Related Topics 	  All Examples

The following command grants user SCOTT access to database library lib1:

.GRANT LIB lib1 USER scott


REVOKE command (Database commands)

  Examples	   Related Topics 	  Alphabetic List

Description	Revokes a user's access to a library stored in the database.

Syntax

REVOKE LIBRARY name USER name

Keywords and Values

LIBRARY name	Specifies a library.
USER name	Specifies a user.
Comments	You can specify any single valid user name, or PUBLIC (all users).


REVOKE command example (Database commands)

  Related Topics 	  All Examples

The following command revokes user SCOTT's access to database library lib1:

.REVOKE LIB lib1 USER scott


STORE command

  Examples	   Related Topics 	  Alphabetic List

Description	Stores one or more program units in the database.

Syntax

STORE PROGRAMUNIT name [, name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]
      [NOWARN]

STORE PACKAGE name[, name...]
      [OWNER name]
      [SPECIFICATION | BODY]

STORE SUBPROGRAM name[, name...]
      [OWNER name]
      [SPECIFICATION | BODY]

STORE PROCEDURE name[, name...]
      [OWNER name]
      [SPECIFICATION | BODY]

STORE FUNCTION name[, name...]
      [OWNER name]
      [SPECIFICATION | BODY]

Keywords and Values

PROGRAMUNIT name	Specifies one or more program units.
PACKAGE name	Specifies one or more packages.
SUBPROGRAM name	Specifies one or more subprograms.
PROCEDURE name	Specifies one or more procedures.
FUNCTION name	Specifies one or more functions.
OWNER name	Specifies the owner of the stored program unit(s).
SPECIFICATION or BODY	Dictates whether the specification or body of a package is stored in the database, respectively.
Comments	If OWNER is not specified, Procedure Builder assigns the currently connected user as the owner of the stored program units.

If neither SPECIFICATION nor BODY is supplied, both the body and the specification (if available) of the designated package(s) are stored in the database.


STORE command examples

  Related Topics 	  All Examples

The following command stores procedure proc1 and function func2 in the current database:

.STORE PROGRAMUNIT proc1, func2

The following command stores the specification and body of package pack1 and specifies the owner to be SCOTT:

.STORE PACK pack1 OWNER scott


ATTACH command

  Examples	   Related Topics 	   Alphabetic List

Description	Attaches a PL/SQL library to the current session.

Syntax

ATTACH LIBRARY [directory]name[extension]
       [FILESYSTEM | DB]
       [BEFORE library]
       [AFTER library]
       [START | END]

Keywords and Values

LIBRARY name	Specifies the name of the library, including the optional directory path and extension if stored in the file system.
FILESYSTEM or DB	Specifies whether the specified library is stored in the file system or in the currently connected database. If neither keyword is specified, tries to access the specified library first in the file system and then, if unsuccessful, in the current database.
BEFORE library	Specifies to attach the library before the named attached library.
AFTER library	Specifies to attach the library after the named attached library.
START or END	Specifies whether the attached library is placed at the beginning or the end of the attach list, respectively.  The default is START.
Comments	If you attempt to attach a library in the file system, the load path and the extension .pll are used when resolving lib-name, unless directory and extension are specified explicitly.  Note that the syntax of directory is operating system-specific.  For more information about syntax, see the Oracle product documentation for your operating system.

Libraries are attached read-only.  If you want to modify the contents of a library, use the OPEN command to open the library for editing.


ATTACH command example

  Related Topics 	  All Examples

The following command attaches to the library residing in the file lib1:

.ATTACH LIB lib1 FILE


CLOSE command

  Examples 	   Related Topics 	  Alphabetic List

Description	Removes one or more libraries from the current set of open libraries.

Syntax

CLOSE LIBRARY name[, name...] [DISCARD]

Keywords and Values

LIBRARY name	Specifies one or more currently open libraries that you wish to close.
DISCARD	Discards changes made to the libraries since the last save.
Comments	Closing a library removes all program units loaded from that library into the environment.  The namespace used to represent the library is also removed.

Closing a library automatically saves any changes made to the library since it was opened.  Specifying DISCARD discards any changes made to the library since the last save operation.


CLOSE command example

  Related Topics 	  All Examples

The following command closes the libraries lib1 and lib2:

.CLOSE LIB lib1, lib2


COMPILE (libraries) command

  Examples	   Related Topics 	  Alphabetic List

Description	Compiles/recompiles all of the program units in one or more open libraries.

Syntax

COMPILE LIBRARY name[, name...] [INCREMENTAL]

Keywords and Values

LIBRARY name	Specifies one or more open libraries whose program units you wish to compile.
INCREMENTAL	Compiles only those program units within the library that need to be compiled.
Comments	When invoked, COMPILE first checks for any currently loaded program unit(s) that match the name and type of the program unit(s) in the library to be compiled.  If there is at least one match, you are asked if you wish to continue compilation.

Answering Yes removes all of the matching program units from the environment, compiles them, and saves them in the specified open library.  Answering No aborts the operation.

Note: The compiled program unit(s) are saved in the open library, but are not reloaded into the environment.  You can invoke the LOAD command (via the Interpreter command line or File [image] Load) to reload them into the environment.

If INCREMENTAL is not specified, all program units in the library are force-compiled.


COMPILE (libraries) command example

  Related Topics 	  All Examples

The following command compiles all of the program units in the open library named lib1:

.COMPILE LIB lib1


CREATE (libraries) command

  Examples	   Related Topics 	  Alphabetic List

Description	Creates a new library that can be stored in either the file system or the current database.

Syntax

CREATE LIBRARY [directory]lib-name[extension]
       [SOURCE pld-file]
       [NOCOMPILE]
       [FILESYSTEM | DB]
       [BEFORE | AFTER]
       [NOCONFIRM]

Keywords and Values

LIBRARY name	Specifies the name of the library, including the optional directory path and extension if created in the file system.
SOURCE pld-file	Specifies a file containing the source of one or more program units.
NOCOMPILE	Prevents the contents of the newly created library from being compiled.
FILESYSTEM or DB	Indicates whether the specified library should be created in the file system or in the currently connected database.  The default is FILESYSTEM.
BEFORE or AFTER	Dictates whether the attached library is placed at the beginning or the end of the attach list, respectively.  The default is BEFORE.
NOCONFIRM	Specifies to overwrite an existing library without prompting you for confirmation.
Comments	For libraries created in the file system, the name of the library is designated by the basename of the file (the full filename minus any leading directory and any trailing extension).  For example, in UNIX, the file /private/libs/emplib.pll holds the library named emplib.

The syntax of directory is operating system-specific.  For more information about syntax, see the Oracle product documentation for your operating system.

The newly created library is automatically opened.  Once a library has been opened, you can modify its contents using the INSERT and DELETE commands.

Using the SOURCE keyword, you can immediately populate the newly created library with the source of one or more program units contained in the specified pld-file.  The library is then compiled (using the COMPILE LIBRARY command) unless you specify the NOCOMPILE keyword.

If you try to create a library with the same name as an existing library, a message box displays, asking if you want to overwrite the existing library.  Specifying NOCONFIRM in the command string suppresses the alert.


CREATE (libraries) command example

  Related Topics 	  All Examples

In UNIX, the following command creates a new library named lib1 residing in the file /private/libs/lib1.pll:

.CREATE LIBRARY /private/libs/lib1.pll FILE


DELETE (libraries) command

  Examples	   Related Topics 	  Alphabetic List

Description	Deletes one or more libraries that reside in the current database.

Syntax

DELETE LIBRARY name[, name...]

Keywords and Values

LIBRARY name	Specifies a library.
Comments	You cannot delete a library that is currently attached.  Use the DETACH command to detach a library before you delete it.


DELETE (libraries) command example

  Related Topics 	  All Examples

The following command deletes library lib1 from the database:

.DELETE LIB lib1


DELETE (library program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Deletes one or more program units from an open library.

Syntax

DELETE PROGRAMUNIT name [, name...]
        LIBRARY name
     [SPECIFICATION | BODY]

DELETE PACKAGE name [, name...]
        LIBRARY name
     [SPECIFICATION | BODY]

DELETE SUBPROGRAM name [, name...]
        LIBRARY name
     [SPECIFICATION | BODY]

DELETE PROCEDURE name [, name...]
        LIBRARY name
     [SPECIFICATION | BODY]

DELETE FUNCTION name [, name...]
        LIBRARY name
     [SPECIFICATION | BODY]

Keywords and Values

PROGRAMUNIT name	Specifies one or more program units.
PACKAGE name	Specifies one or more packages.
SUBPROGRAM name	Specifies one or more subprograms.
PROCEDURE name	Specifies one or more procedures.
FUNCTION name	Specifies one or more functions.
LIBRARY name	Specifies the library from which the program unit(s) should be deleted.
SPECIFICATION or BODY	Specifies that either the specification or the body of the program unit be deleted.


DELETE (library program units) command example

  Related Topics 	  All Examples

The following command deletes the package named p2 from the library named lib1:

.DELETE PACKAGE p2 LIBRARY lib1


DESCRIBE (libraries) command

  Examples	   Related Topics 	  Alphabetic List

Description	Displays detailed information about an attached library.

Syntax

DESCRIBE LIBRARY name

Keywords and Values

LIBRARY name	Specifies the name of an attached library.
Comments	The information displayed for a library includes the mode in which it was attached, its external location, and its contents.


DESCRIBE (libraries) command example

  Related Topics 	  All Examples

The following command displays information about the library named lib1:

.DESCRIBE LIBRARY lib1


DETACH command

  Examples	   Related Topics 	  Alphabetic List

Description	Removes one or more libraries from the current set of attached libraries.

Syntax

DETACH LIBRARY name[, name...]

Keywords and Values

LIBRARY name	Specifies one or more attached libraries.
Comments	Detaching a library removes all unmodified program units loaded from that library into the environment.  Note that once a program unit loaded from a library has been modified within the environment (e.g., by compilation), it will not be removed when the library is detached.


DETACH command example

  Related Topics 	  All Examples

The following command detaches the libraries lib1 and lib2:

.DETACH LIBRARY lib1, lib2


EXPORT (libraries) command

  Examples	   Related Topics 	  Alphabetic List

Description	Writes the source of a library to a text file.

Syntax

EXPORT {LIBRARY name}
       FILE [directory]name[extension]
      [NOWARN]

Keywords and Values

LIBRARY name	Specifies an attached library.
FILE name	Specifies the name of the file, including the optional directory path and extension.
NOWARN	Suppresses the warning that a built-in program unit was not added to the attached library.
Comments	If unspecified, the file extension defaults to .pld.  The syntax of directory is operating system-specific.  For more information about syntax, see the Oracle product documentation for your operating system.


EXPORT (libraries) command example

  Related Topics 	  All Examples

The following command writes the source of procedure p1 and function f3 to the file pl1.pld:

.EXPORT LIB my_lib FILE lib1


GENERATE command

  Examples	   Related Topics 	  Alphabetic List

Description	Creates a runtime version of a currently open library.

Syntax

GENERATE LIBRARY name
         FILE [directory]name
       [INCREMENTAL]

Keywords and Values

LIBRARY name	Specifies the name of the open library.
FILE name	Specifies the file name of the runtime library, including the optional directory path.  The default file extension .plx is automatically assigned.
INCREMENTAL	Specifies that only the uncompiled program units in the open library are to be compiled.
Comments	This command creates a temporary library, copies all program units from the open library and inserts them in the temporary library, compiles the program units, then executes the SAVE command on the temporary library using the NOSOURCE and NODIANA keywords.

The resulting library is identified as a runtime only library with the .plx file extension.  If you specify a different file extension, that extension will be used instead of .plx.


GENERATE command example

  Related Topics 	  All Examples

The following command creates a runtime library named runlib1.plx based on the open library mylib.pll:

.GENERATE LIB mylib FILE runlib1

Since the INCREMENTAL keyword was not specified, all program units in the library mylib will be force compiled.


GRANT command (Library commands)

  Examples	   Related Topics 	  Alphabetic List

Description	Grants a user access to a library stored in the database.

Syntax

GRANT LIBRARY name USER name

Keywords and Values

LIBRARY name	Specifies the library.
USER name	Specifies a user name.
Comments	You can specify any single valid user name, or PUBLIC (all users).


GRANT command example (Library commands)

  Related Topics 	  All Examples

The following command grants user SCOTT access to database library lib1:

.GRANT LIB lib1 USER scott


INSERT (library program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Inserts one or more program units into an open library.

Syntax

INSERT PACKAGE name[, name...]
      [SPECIFICATION | BODY]
       LIBRARY name
      [NOPCODE] [NODIANA] [NOSOURCE] [NOWARN]

INSERT SUBPROGRAM name [, name...]
      [SPECIFICATION | BODY]
       LIBRARY name
      [NOPCODE] [NODIANA] [NOSOURCE] [NOWARN]

INSERT PROCEDURE name [, name...]
      [SPECIFICATION | BODY]
       LIBRARY name
      [NOPCODE] [NODIANA] [NOSOURCE] [NOWARN]

INSERT FUNCTION name [, name...]
      [SPECIFICATION | BODY]
       LIBRARY name
      [NOPCODE] [NODIANA] [NOSOURCE] [NOWARN]

Keywords and Values

PACKAGE name	Specifies one or more packages.
SUBPROGRAM name	Specifies one or more subprograms.
PROCEDURE name	Specifies one or more procedures.
FUNCTION name	Specifies one or more functions.
SPECIFICATION or BODY	Specifies the specification or the body of the designated program unit(s), respectively.  If neither keyword is supplied, both are inserted into the library.
LIBRARY name	Specifies the target library.
NOPCODE	Adds the program unit(s) to the library without the PCODE.
NODIANA	Adds the program unit(s) to the library without the DIANA.
NOSOURCE	Adds the program unit(s) to the library without the source code.
NOWARN	Suppresses the warning that a built-in program unit was not inserted into the open library.
Comments	You can use NODIANA and NOSOURCE to dramatically reduce the size of a PL/SQL library.

Note: Program units inserted into libraries with NODIANA and NOSOURCE can be used only in a runtime environment, because it is impossible to compile references to program units that do not include DIANA.

Attempting to insert a built-in program unit into an open library (e.g., .INSERT PROG * LIB lib3) displays a warning in the Interpreter pane (Warning: Program unit <progunit name> has no source to insert...).  Specifying NOWARN in the command string suppresses the warning.


INSERT (library program units) command example

  Related Topics 	  All Examples

The following command inserts the packages p1 and p2 into the library named lib1:

.INSERT PACKAGE p1,p2 LIBRARY lib1


LOAD (library program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Loads one or more program units from an attached library.

Syntax

LOAD PROGRAMUNIT name[, name...]
      LIBRARY name
     [SPECIFICATION | BODY]
     [NOCONFIRM]

LOAD PACKAGE name [, name...]
      LIBRARY name
     [SPECIFICATION | BODY]
     [NOCONFIRM]

LOAD SUBPROGRAM name [, name...]
      LIBRARY name
     [SPECIFICATION | BODY]
     [NOCONFIRM]

LOAD PROCEDURE name [, name...]
      LIBRARY name
     [SPECIFICATION | BODY]
     [NOCONFIRM]

LOAD FUNCTION name [, name...]
      LIBRARY name
     [SPECIFICATION | BODY]
     [NOCONFIRM]

Keywords and Values

PROGRAMUNIT name	Specifies one or more program units.
PACKAGE name	Specifies one or more packages.
SUBPROGRAM name	Specifies one or more subprograms.
PROCEDURE name	Specifies one or more procedures.
FUNCTION name	Specifies one or more functions.
LIBRARY name	Specifies an attached library.
SPECIFICATION or BODY	Specifies that either the specification or the body of the program unit be loaded, respectively.  If neither is specified, both are loaded.
NOCONFIRM	Specifies to redefine an existing program unit without prompting you for confirmation.
Comments	If you try to load a library program unit with the same name and type as an existing program unit, a message box displays, asking if you want to redefine the existing program unit.  Specifying NOCONFIRM in the command string suppresses the alert.


LOAD (library program units) command example

  Related Topics 	  All Examples

The following command loads the function f1 and the procedure p3, both of which are stored in the attached library lib1:

.LOAD PROGRAMUNIT f1, p3 LIB lib1


OPEN command

  Examples	   Related Topics 	  Alphabetic List

Description	Opens a library for modification.

Syntax

OPEN LIBRARY [directory]lib-name[extension]
     [FILESYSTEM | DB]

Keywords and Values

LIBRARY name	Specifies the name of the library, including the optional directory path and extension if stored in the file system.
FILESYSTEM or DB	Specifies whether the specified library is stored in the file system or in the currently connected database.  The default is FILESYSTEM.
Comments	If neither FILESYSTEM nor DB is specified, Procedure Builder tries to access the specified library first in the file system and then, if unsuccessful, in the current database.

If you attempt to open a library in the file system, the load path and the extension .pll are used when resolving lib-name, unless directory and extension are specified explicitly.  Note that the syntax of directory is operating system-specific.  For more information about syntax, see the Oracle product documentation for your operating system.


OPEN command examples

  Related Topics 	  All Examples

The following command opens the library named lib1, which is stored in the file system.

.OPEN LIB /private/libs/lib1

The following command opens the library named libdb, which is stored in the current database:

.OPEN LIB libdb DB


RENAME (libraries) command

  Examples	   Related Topics 	  Alphabetic List

Description	Renames a library that resides in the current database.

Syntax

RENAME LIBRARY oldname TO newname

Keywords and Values

LIBRARY oldname	Specifies the current library name.
TO newname	Specifies the new library name.
Comments	You cannot rename a library to the name of a library that is currently attached.  Use the DETACH command to detach the library specified by the new name, or use a different new name.

You cannot use this command to rename libraries stored in files.  You must use operating system commands.


RENAME (libraries) command example

  Related Topics 	  All Examples

The following command renames database library lib1 to lib4:

.RENAME LIB lib1 TO lib4


REVERT command

  Examples	   Related Topics 	  Alphabetic List

Description	Reverts one or more libraries to their previously saved state.

Syntax

REVERT LIBRARY name[, name...]

Keywords and Values

LIBRARY name	Specifies one or more open libraries.


REVERT command example

  Related Topics 	  All Examples

The following command reverts the library lib1:

.REVERT LIB lib1


REVOKE command (Library commands)

  Examples	   Related Topics 	  Alphabetic List

Description	Revokes a user's access to a library stored in the database.

Syntax

REVOKE LIBRARY name USER name

Keywords and Values

LIBRARY name	Specifies a library.
USER name	Specifies a user.
Comments	You can specify any single valid user name, or PUBLIC (all users).


REVOKE command example (Library commands)

  Related Topics 	  All Examples

The following command revokes user SCOTT's access to database library lib1:

.REVOKE LIB lib1 USER scott


SAVE command

  Examples	   Related Topics 	  Alphabetic List

Description	Saves changes made to one or more open libraries.

Syntax

SAVE LIBRARY name[, name...]
     [AS name]
     [NOPCODE]
     [NODIANA]
     [NOSOURCE]

Keywords and Values

LIBRARY name	Specifies one or more open libraries.
AS name	Specifies a new name for the saved library.
NOPCODE	Saves the library without the PCODE.
NODIANA	Saves the library without the DIANA.
NOSOURCE	Saves the library without the source code.
Comments	Saving a library issues an implicit COMMIT.  This operation commits any changes made to any database object, not just library objects.  For more information on COMMIT, refer to the Oracle8 SQL Reference Manual.

You can use NODIANA and NOSOURCE to dramatically reduce the size of a PL/SQL library.

Note: Libraries saved with NODIANA and NOSOURCE can be used only in a runtime environment, because it is impossible to compile references to library program units that do not include DIANA.


SAVE command examples

  Related Topics 	  All Examples

The following command saves the libraries lib1 and lib2:

.SAVE LIB lib1, lib2

The following command saves library lib1 as library lib1a:

.SAVE LIB lib1 AS lib1a

The following command saves the libraries lib1 and lib2 without DIANA or source:

.SAVE LIB lib1, lib2 NODIANA NOSOURCE


SHOW (libraries) command

  Examples	   Related Topics 	  Alphabetic List

Description	Enumerates the libraries that are currently attached.

Syntax

SHOW LIBRARIES


SHOW (libraries) command example

  Related Topics 	  All Examples

The following command displays the currently attached libraries:

.SHOW LIB


DESCRIBE (version) command

  Examples	   Related Topics 	  Alphabetic List

Description	Displays detailed information about the current version of Procedure Builder and the PL/SQL compiler.

Syntax

DESCRIBE VERSION


DESCRIBE (version) command example

  Related Topics 	  All Examples

The following command displays information about Procedure Builder:

.DESCRIBE VER


HELP command

  Examples	   Related Topics 	  Alphabetic List

Description	Provides descriptions and syntax summaries for commands.

Syntax

HELP [COMMAND name] [SYNTAX]

Keywords and Values

COMMAND name	Specifies the Procedure Builder command.
SYNTAX	Displays the syntax of the specified command.
Comments	If no command name is supplied, a list of all Procedure Builder commands is displayed.


HELP command examples

  Related Topics 	  All Examples

The following command displays a brief description and the syntax of the BREAK command:

.HELP COM BREAK SYNTAX

The following command lists all of Procedure Builder commands:

.HELP


INTERPRET command

  Examples	   Related Topics 	  Alphabetic List

Description	Executes one or more Procedure Builder scripts.

Syntax

INTERPRET FILE name[, name...]
          [ECHO]
          [SILENT]
          [NOCONFIRM]

Keywords and Values

FILE name	Specifies a file containing a Procedure Builder script.
ECHO	Displays each line of the script as it is processed.
SILENT	Suppresses status messages issued by the Interpreter.
NOCONFIRM	Specifies to redefine an existing program unit without prompting you for confirmation.
Comments	A Procedure Builder script consists of a sequence of constructs that can be any combination of program units, Procedure Builder commands, and SQL statements.  The script is processed as if its contents had been typed directly into the Interpreter.  Each PL/SQL construct found in the script is processed as if it had been loaded individually by the LOAD command.

If unspecified, the file extension(s) default to .pld.

If you try to load a program unit with the same name and type as an existing program unit, a message box displays, asking if you want to redefine the existing program unit.  Specifying NOCONFIRM suppresses the alert.

You can include SQL statements in your script, but SQL*Plus statements and syntax are not supported.

INTERPRET provides a mechanism for loading multiple program units from a single file.  However, INTERPRET lacks the performance of LOAD because Procedure Builder must preparse the source text and send program units to the PL/SQL compiler one at a time.


INTERPRET command example

  Related Topics 	  All Examples

The following command interprets (with ECHO enabled) the script in the file named script1:

.INTERPRET FILE script1 ECHO


QUIT command

  Related Topics 	  Alphabetic List

Description	Exits the current Procedure Builder session.  This command is valid only when Procedure Builder is invoked as a standalone session.

Syntax

QUIT [NOCONFIRM]


CREATE (bind variable) command

  Examples	   Related Topics 	   Alphabetic List

Description	Creates a bind variable.  This command is valid only when Procedure Builder is invoked as a standalone session.

Syntax

CREATE CHAR var_name [LENGTH number]

CREATE NUMBER var_name [PRECISION number] [SCALE number]

CREATE RAW var_name [LENGTH number]

CREATE DATE var_name

Keywords and Values

CHAR var_name	Specifies a bind variable, var_name, of the datatype CHAR.
LENGTH number	Optionally specifies the length of a CHAR  bind variable.
DATE var_name	Specifies a bind variable, var_name, of the datatype DATE
NUMBER var_name	Specifies a bind variable, var_name, of the datatype NUMBER.
PRECISION number	Optionally determines a maximum number of numeric digits for the variable.
SCALE  number	Optionally determines where rounding should occur.
RAW var_name	Specifies a bind variable, var_name, of the datatype RAW.
Comments	The LENGTH attribute of the CHAR datatype defaults to 1 byte if you do not specify an alternate setting.  The maximun value for LENGTH is 32767 bytes.

The maximum value for PRECISION is 38 characters.  SCALE can be from -84 to 127.  If you do not specify a value for SCALE, it defaults to zero, meaning numbers are rounded to the nearest whole number.

For more information about datatypes and their attributes, see the PL/SQL User's Guide and Reference.


CREATE (bind variable) command example

  Related Topics 	  All Examples

The following command creates a bind variable x of the datatype NUMBER that should round to the nearest hundredth decimal place:

.CREATE NUMBER x SCALE 2


DELETE (bind variables) command

  Examples	   Related Topics 	  Alphabetic List

Description	Deletes one or more bind variables.  This command is valid only when Procedure Builder is invoked as a standalone session.

Syntax

DELETE BINDVAR name [, name...]

DELETE CHAR name [, name...]

DELETE DATE name [, name...]

DELETE NUMBER name [, name...]

Keywords and Values

BINDVAR name	Specifies a bind variable or set of bind variables of any datatype
CHAR name	Specifies a bind variable or set of bind variables of the datatype CHAR
DATE name	Specifies a bind variable or set of bind variables of the datatype DATE
NUMBER name	Specifies a bind variable or set of bind variables of the datatype NUMBER


DELETE (bind variables) command examples

  Related Topics 	  All Examples

The following command deletes the bind variable y of the datatype CHAR:

.DELETE CHAR y

The following command deletes a set of bind variables (x, y, and z) of different datatypes:

.DELETE BINDVAR x,y,z


Using Interpreter commands

  Related Topics

Commands adhere to the following general syntax:

.command-name [option...]

In other words, a command consists of a period (.), then the command name, followed by zero or more keywords and keyword value arguments.

Command options generally follow the form shown below:

keyword

or

keyword value(s)

Thus, an option consists of either a single keyword, or a keyword followed by one or more argument values.  The command name, keywords, and argument values are separated by white space.  Command names, keywords, and argument values are not case sensitive.

For example, the following DESCRIBE command invocation illustrates the basic elements of Procedure Builder command syntax:

.DESCRIBE PROCEDURE proc1 BODY

The command name DESCRIBE is followed by the PROCEDURE and BODY keywords.  The PROCEDURE takes a single argument value, proc1, while the BODY keyword takes no argument values.

Multi-valued Arguments 	Keyword arguments may be multi-valued, in which case the individual values are delimited by commas as shown below:

value, value...

Spaces may appear between the commas and neighboring values.

Keyword arguments that can be multi-valued according to the syntax specified above will be described as shown below:

name[, name...]

For example, the LOAD command has the following partial syntax:

.LOAD FILE name[, name...]

Thus, the file argument can be single-valued as shown below:

.LOAD FILE file1

or multi-valued as shown below:

.LOAD FILE file1, file2, file3

Position Independence 	Unless explicitly specified in the syntax descriptions, keywords may appear in any order.  For example, the command:

.DESCRIBE PROCEDURE proc1 BODY

can also be entered as:

.DESCRIBE BODY PROCEDURE proc1

Multi-line Commands 	Normally, commands are terminated by a newline character or a carriage return.  However, it is often desirable to make a command span multiple lines.  This can be done by including the continuation character (backslash by default) as the last character of each line to be continued.  For example, the continuation character is used below to place each file name argument value to the LOAD command on a separate line:

.LOAD FILE long_file_name_number_one, \
long_file_name_number_two, \
long_file_name_number_three

Argument Value Quoting 	Non-numeric command argument values may be optionally enclosed in double quotes.  The quotes serve only as delimiters and are not considered part of the argument value.  This is particularly useful in specifying argument values that contain white space, commas, or wildcard characters.  For example, if supported by the native operating system, a file name containing a space could be specified in a load command as follows:

.LOAD FILE "my file"

A double quote may be included as a part of the argument value by preceding it with another double quote.  For example, the command

.LOAD FILE ""quoted file""

loads a file with a name containing two double quotes--one at the beginning and one at the end.

Abbreviating Keywords 	A command keyword may be abbreviated by typing only as many characters as it takes to distinguish it from all other keywords accepted by the same command.

Command names may not be abbreviated.  This is to minimize conflict with the PL/SQL namespace and avoid confusion in distinguishing between commands and PL/SQL code fragments.

Entering PL/SQL Code 	In addition to commands, the Interpreter accepts and evaluates PL/SQL constructs (e.g., statements, blocks, procedure definitions, etc.), and SQL statements.  Procedure Builder interprets a line beginning with anything other than a valid command name as the beginning of a PL/SQL statement, block, program unit, or SQL statement.

While commands occupy a single line (unless the continuation character is used), PL/SQL or SQL statements may occupy any number of lines, and continuation characters are neither necessary nor allowed.

If necessary, a PL/SQL construct can always be distinguished from a command by enclosing it in the block delimiters BEGIN and END.

Notational Conventions 	The following table describes the notation and conventions for command syntax used in this section.

Feature	Example	Explanation
uppercase	BREAK	A command or keyword name; it need not be typed in uppercase
lowercase italics	numbers	A keyword value; substitute an appropriate value
vertical bar	|	Separates alternative syntax elements that may be optional or mandatory
braces	{STACK|SCOPE}	A choice of mandatory items; enter one of the items separated by |.  Do not enter the braces or vertical bar.
brackets	[BEFORE|AFTER]	One or more optional items.  If two items appear separated by a vertical bar, enter one of the items.  Do not enter the brackets or vertical bar.
underline	[BEFORE|AFTER]	A default value.  If you enter nothing, this value is used.
Enter other punctuation marks (such as commas) where shown in the command syntax.


Alphabetic list of commands

ATTACH

BREAK

CLOSE

COMPILE (libraries)

COMPILE (program units)

CONNECT

CREATE (bind variables)

CREATE (libraries)

DELETE (bind variables)

DELETE (debug actions)

DELETE (libraries)

DELETE (library program units)

DELETE (load path)

DELETE (program units)

DESCRIBE (debug actions)

DESCRIBE (load path)

DESCRIBE (locals)

DESCRIBE (libraries)

DESCRIBE (program units)

DESCRIBE (tables and views)

DESCRIBE (version)

DETACH

DISABLE (compiler options)

DISABLE (debug actions)

DISABLE (logging)

DISCONNECT

ENABLE (compiler options)

ENABLE (debug actions)

ENABLE (logging)

EXECUTE

EXPORT

GENERATE

GO

GRANT

HELP

INSERT (library program unit)

INSERT (load path)

INTERPRET

LIST (debug actions)

LIST (program units)

LOAD (library program units)

LOAD (program units)

LOAD (stored program units)

LOG

OPEN

QUIT

RENAME

RESET

REVERT

REVOKE

SAVE

SET (scope)

SHOW (call stack)

SHOW (debug actions)

SHOW (libraries)

SHOW (locals)

SHOW (program units)

STEP

STORE

TRIGGER


No commands begin with this letter.


Bind variable commands

  Alphabetic List 	  Related Topics

CREATE (bind variables)

DELETE (bind variables)


Database commands

  Alphabetic List 	  Related Topics

CONNECT

DESCRIBE (tables and views)

DISCONNECT

GRANT

REVOKE

STORE


Debug action commands

  Alphabetic List 	  Related Topics

BREAK

DELETE (debug actions)

DESCRIBE (debug actions)

DISABLE (debug actions)

ENABLE (debug actions)

LIST (debug actions)

SHOW (debug actions)

TRIGGER


Debugging commands

  Alphabetic List 	  Related Topics

DESCRIBE (locals)

GO

RESET

SET (scope)

SHOW (call stack)

STEP


Library commands

  Alphabetic List 	  Related Topics

ATTACH

CLOSE

COMPILE (libraries)

CREATE (libraries)

DELETE (libraries)

DELETE (library program unit)

DESCRIBE (libraries)

DETACH

EXPORT (libraries)

GENERATE

GRANT

INSERT (library program unit)

LOAD (library program units)

OPEN

RENAME

REVERT

REVOKE

SAVE

SHOW (libraries)


Load path commands

  Alphabetic List 	  Related Topics

DELETE (load path)

DESCRIBE (load path)

INSERT (load path)


Logging commands

  Alphabetic List 	  Related Topics

DISABLE (logging)

ENABLE (logging)

LOG


Program unit commands

  Alphabetic List 	  Related Topics

COMPILE (program units)

DELETE (program units)

DESCRIBE (program units)

DISABLE (compiler options)

ENABLE (compiler options)

EXECUTE

EXPORT (program units)

EXPORT (stored program units)

LIST (program units)

LOAD (program units)

LOAD (stored program units)

SHOW (locals)

SHOW (program units)


Session commands

  Alphabetic List 	  Related Topics

DESCRIBE (version)

HELP

INTERPRET

QUIT


No library commands begin with this letter.


Interpreter commands

  Alphabetic List 	  Related Topics

Bind variable commands

Database commands

Debug action commands

Debugging commands

Library commands

Load path commands

Logging commands

Program unit commands

Session commands


COMPILE (program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Compiles/recompiles the specified program units.

Syntax

COMPILE PROGRAMUNIT name[, name...]
      [SPECIFICATION | BODY]

COMPILE PACKAGE name[, name...]
      [SPECIFICATION | BODY]

COMPILE SUBPROGRAM name[, name...]
      [SPECIFICATION | BODY]

COMPILE PROCEDURE name[, name...]
      [SPECIFICATION | BODY]

COMPILE FUNCTION name[, name...]
      [SPECIFICATION | BODY]

Keywords and Values

PROGRAMUNIT name	Specifies one or more program units.
PACKAGE name	Specifies one or more packages.
SUBPROGRAM name	Specifies one or more subprograms.
PROCEDURE name	Specifies one or more procedures.
FUNCTION name	Specifies one or more functions.
SPECIFICATION or BODY	Specifies that either the specification or the body of the program unit be compiled.  By default, both are compiled


COMPILE (program units) command example

  Related Topics 	  All Examples

The following command compiles procedure proc1 and package pkg1:

.COMPILE PROG proc1, pkg1


DELETE (program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Deletes one or more program units from the current development session.

Syntax

DELETE PROGRAMUNIT name [, name...]
     [SPECIFICATION | BODY]

DELETE PACKAGE name [, name...]
     [SPECIFICATION | BODY]

DELETE SUBPROGRAM name [, name...]
     [SPECIFICATION | BODY]

DELETE PROCEDURE name [, name...]
     [SPECIFICATION | BODY]

DELETE FUNCTION name [, name...]
     [SPECIFICATION | BODY]

Keywords and Values

PROGRAMUNIT name	Specifies one or more program units.
PACKAGE name	Specifies one or more packages.
SUBPROGRAM name	Specifies one or more subprograms.
PROCEDURE name	Specifies one or more procedures.
FUNCTION name	Specifies one or more functions.
SPECIFICATION or BODY	Specifies that either the specification or the body of the program unit be removed.  By default, both are removed.
Comments	Once deleted from the current development session, a program unit and any of its subobjects (types, variables, subprograms, etc.) are no longer defined within the development session.  Deleting a program unit from the current development session can cause the invalidation of other program units that depend upon it.  This is analogous to what happens when the specification of a program unit is changed.


DELETE (program units) command example

  Related Topics 	  All Examples

The following command deletes the package named p2 from the current development session:

.DELETE PACKAGE p2


DESCRIBE (program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Displays detailed information about a specific program unit instance.

Syntax

DESCRIBE PROGRAMMUNIT name [SPECIFICATION | BODY]

DESCRIBE PACKAGE name [SPECIFICATION | BODY]

DESCRIBE SUBPROGRAM name [SPECIFICATION | BODY]

DESCRIBE PROCEDURE name [SPECIFICATION | BODY]

DESCRIBE FUNCTION name [SPECIFICATION | BODY]

Keywords and Values

PROGRAMUNIT name	Specifies a program unit.
PACKAGE name	Specifies a package.
SUBPROGRAM name	Specifies a subprogram.
PROCEDURE name	Specifies a procedure.
FUNCTION name	Specifies a function.
SPECIFICATION or BODY	Specifies that either the specification or the body of the program unit be added to the library.  The default is SPECIFICATION.
Comments	The information displayed includes the program unit name, its type, its parameters (if any), its external location, whether it is compiled, whether it is open for editing, and cross reference information.  In addition, describing a package also indicates whether the package is a built-in program unit, and whether it is an extension to the STANDARD package.

Describing a package specification lists all of the subprograms defined within the specification.


DESCRIBE (program units) command example

  Related Topics 	  All Examples

The following command displays information about the body of package pkg1:

.DESCRIBE BODY PACKAGE pkg1


DISABLE (compiler options) command

  Examples	   Related Topics 	  Alphabetic List

Description	Removes one or more compiler options temporarily.

Syntax

DISABLE COMPILER SIZECHECK

Comments	The SIZECHECK compiler option is automatically disabled for batch compilations.  You can reactivate a compiler option using the ENABLE command.


DISABLE (compiler options) command example

  Related Topics 	  All Examples

The following command temporarily disables the SIZECHECK compiler option:

.DISABLE COMPILER SIZECHECK


ENABLE (compiler options) command

  Examples	   Related Topics 	  Alphabetic List

Description	Activates or reactivates one or more compiler options.

Syntax

ENABLE COMPILER SIZECHECK

Comments	You can activate the SIZECHECK compiler option for interactive compilations only.  Once enabled, the compiler option remains active until disabled.  This option is automatically disabled for batch compilations.

Enable the SIZECHECK option prior to compiling a program unit to raise an alert if the size of a program unit source is approaching an operating system limit for memory allocation.  If the size of the source is close to an operating system limit, the compiled state of that source will probably be larger and may exceed the operating system limit.

The SIZECHECK option also raises an alert if the compiled state of the program unit is approaching or exceeds an operating system specific limit for memory allocation.

If the source of the program unit, or the compiled program unit exceeds an operating system-specific memory allocation limit, you may wish to break the program unit into smaller program units.

Check your operating system documentation for the memory allocation limit on your platform.

You can temporarily remove a compiler option using the DISABLE command.


ENABLE (compiler options) command example

  Related Topics 	  All Examples

The following command enables the SIZECHECK compiler option:

.ENABLE COMPILER SIZECHECK


EXECUTE command

  Examples	   Related Topics 	  Alphabetic List

Description	Executes a named anonymous block or a parameterless procedure.  This command is valid only when Procedure Builder is invoked as a standalone session.

Syntax

EXECUTE PROGRAMUNIT name

EXECUTE PROCEDURE name

Keywords and Values

PROGRAMUNIT name	Specifies a named anonymous block.
PROCEDURE name	Specifies a parameterless procedure.
Comments	Use the EXECUTE command to execute program units and procedures that have no source or that have not been compiled.


EXECUTE command example

  Related Topics 	  All Examples

You create a library named lib1.pll.  You insert the procedure x1 into that library using the NOSOURCE and NODIANA keywords.  Although the x1 procedure is not compiled, you can run it with the EXECUTE command as follows:

.EXECUTE PROC x1


EXPORT (program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Writes the source of one or more program units to a text file.

Syntax

EXPORT PROGRAMUNIT name [, name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]
      [NOWARN]

EXPORT PACKAGE name [, name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]
      [NOWARN]

EXPORT SUBPROGRAM name [, name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]
      [NOWARN]

EXPORT PROCEDURE name [, name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]
      [NOWARN]

EXPORT FUNCTION name [, name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]
      [NOWARN]

Keywords and Values

PROGRAMUNIT name	Specifies one or more program units.
PACKAGE name	Specifies one or more packages.
SUBPROGRAM name	Specifies one or more subprograms.
PROCEDURE name	Specifies one or more procedures.
FUNCTION name	Specifies one or more functions.
FILE name	Specifies the name of the file, including the optional directory path and extension.
SPECIFICATION or BODY	Specifies either the specification or the body of the designated program unit(s).  By default, both are written to the file.
NOWARN	Suppresses the warning that a built-in program unit has no source for export.
Comments	If you export more than one program unit, Procedure Builder sorts the program units to avoid forward references--that is, each program unit appears after the program unit(s) it references.  This enables you to reload exported program units into Procedure Builder using INTERPRET.

If unspecified, the file extension defaults to .PLD.  The syntax of directory is operating system-specific.  For more information about syntax, see the Oracle product documentation for your operating system.

Attempting to export a built-in program unit to a text file (e.g., .EXPORT PROG * FILE allprogs.txt) displays a warning in the Interpreter pane (Warning: Program unit <progunit name> has no source to export...).  Specifying NOWARN in the command string suppresses the warning.


EXPORT (program units) command example

  Related Topics 	  All Examples

The following command writes the source of procedure p1 and function f3 to the file pl1.pld:

.EXPORT PROG p1,f3 FILE pl1


EXPORT (stored program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Writes the source of one or more stored program units to a text file.

Syntax

EXPORT {STORED} PROGRAMUNIT schema.name [, schema.name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]

EXPORT {STORED} PACKAGE schema.name [,schema.name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]

EXPORT {STORED} SUBPROGRAM schema.name [,schema.name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]

EXPORT {STORED} PROCEDURE schema.name [,schema.name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]

EXPORT {STORED} FUNCTION schema.name [,schema.name...]
       FILE [directory]name[extension]
      [SPECIFICATION | BODY]

Keywords and Values

PROGRAMUNIT name	Specifies one or more program units.
PACKAGE name	Specifies one or more packages.
SUBPROGRAM name	Specifies one or more subprograms.
PROCEDURE name	Specifies one or more procedures.
FUNCTION name	Specifies one or more functions.
FILE name	Specifies the name of the file, including the optional directory path and extension.
SPECIFICATION or BODY	Specifies either the specification or the body of the designated stored program unit(s).  By default, both are written to the file.
Comments	If you export more than one stored program unit, Procedure Builder sorts the stored program units to avoid forward references--that is, each stored program unit appears after the stored program unit(s) it references.  This enables you to reload exported stored program units into Procedure Builder using INTERPRET.

If unspecified, the file extension defaults to .PLD.  The syntax of directory is operating system-specific.  For more information about syntax, see the Oracle product documentation for your operating system.


EXPORT (stored program units) command example

  Related Topics 	  All Examples

The following command writes the source of stored procedure p1 and stored function f3 to the file pl1.pld:

.EXPORT STORED PROG SCOTT.p1,SCOTT.f3 FILE pl1


LIST (program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Displays the specified program unit text and sets the current source location.

Syntax

LIST {[USER schema] PROGRAMUNIT name | PROGRAMUNIT [schema.]name}
     { . | PC | SCOPE}
     [LINE number]
     [SPECIFICATION | BODY]

LIST {[USER schema] PACKAGE name | PACKAGE schema.name}
     { . | PC | SCOPE}
     [LINE number]
     [SPECIFICATION | BODY]

LIST {[USER schema] SUBPROGRAM name | SUBPROGRAM schema.name}
     { . | PC | SCOPE}
     [LINE number]
     [SPECIFICATION | BODY]

LIST {[USER schema] PROCEDURE name | PROCEDURE schema.name}
     { . | PC | SCOPE}
     [LINE number]
     [SPECIFICATION | BODY]

LIST {[USER schema] FUNCTION name | FUNCTION schema.name}
     { . | PC | SCOPE}
     [LINE number]
     [SPECIFICATION | BODY]

Keywords and Values

USER schema	Specifies a schema name in the database where the stored program unit is located.
PROGRAMUNIT name	Specifies a program unit.
PACKAGE name	Specifies a package.
SUBPROGRAM name	Specifies a subprogram.
PROCEDURE name	Specifies a procedure.
FUNCTION name	Specifies a function.
.	Specifies the current source location.  This is the default.
PC	Specifies the current execution location.
SCOPE	Specifies the current scope location.
LINE number	Specifies the line of the program unit that should become the current source location.
SPECIFICATION or BODY	Specifies that either the specification or the body of the program unit be displayed, respectively.  The default is SPECIFICATION.
Comments	LIST displays the text of a program unit in the Source pane of the Interpreter.  If no line is specified using LINE, the first line of the program unit becomes the current source location.

This rule does not apply if you specify ., PC, or SCOPE.  Specifying . or PC sets the source location to the current execution location.  Specifying SCOPE sets the source location to the current scope location.

Note	PC and SCOPE are useful only when program execution has been interrupted.


LIST (program units) command examples

  Related Topics 	  All Examples

The following command displays the source text of procedure p1 and sets the source location to line one:

.LIST PROC p1

The following command displays the source text of p1 and sets the source location to line eighteen:

.LIST PROGRAMUNIT p1 LINE 18

The following command sets the source location to the current execution location and displays the source text:

.LIST PC

The following command displays the source text in a server-side program unit my_proc from the schema owned by user scott and retains the current source location:

.LIST USER scott PROC my_proc

or

.LIST PROC scott.my_proc


LOAD (program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Loads one or more program units from the file system.

Syntax

LOAD FILE [directory]name[extension]
     [, [directory]name...]
     [NOCONFIRM]

Keywords and Values

FILE name	Specifies one or more files containing the program unit text.
NOCONFIRM	Specifies to redefine an existing program unit without prompting you for confirmation.
Comments	Each file you specify must contain the source text of a single program unit.  If unspecified, the directory defaults to the current directory, and the file extension defaults to .pls.

The syntax of directory is operating system-specific.  For more information about syntax, see the Oracle product documentation for your operating system.

The source text is compiled as it is loaded.  If the resulting program unit is a named entity (i.e., a subprogram or package), processing is complete.  If the program unit is an anonymous block, it is executed and automatically discarded upon completion.

If you try to load a program unit with the same name and type as an existing program unit, a message box displays, asking if you want to redefine the existing program unit.  Specifying NOCONFIRM in the command string suppresses the alert.


LOAD (program units) command example

  Related Topics 	  All Examples

The following command loads the program units whose source is contained in the files proc1.pls and func2.pls in the current directory:

.LOAD FILE proc1, func2


LOAD (stored program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Loads one or more program units stored in the database.

Syntax

LOAD STORED PROGRAMUNIT [owner]name[, [owner]name...]
     [SPECIFICATION | BODY]
     [NOCONFIRM]

LOAD STORED PACKAGE [owner]name[, [owner]name...]
     [SPECIFICATION | BODY]
     [NOCONFIRM]

LOAD STORED SUBPROGRAM [owner]name[, [owner]name...]
     [SPECIFICATION | BODY]
     [NOCONFIRM]

LOAD STORED PROCEDURE [owner]name[, [owner]name...]
     [SPECIFICATION | BODY]
     [NOCONFIRM]

LOAD STORED FUNCTION [owner]name[, [owner]name...]
     [SPECIFICATION | BODY]
     [NOCONFIRM]

Keywords and Values

PROGRAMUNIT name	Specifies one or more program units, including the optional owner.
PACKAGE name	Specifies one or more packages, including the optional owner.
SUBPROGRAM name	Specifies one or more subprograms, including the optional owner.
PROCEDURE name	Specifies one or more procedures, including the optional owner.
FUNCTION name	Specifies one or more functions, including the optional owner.
SPECIFICATION or BODY	Specifies that either the specification or the body of the stored program unit be loaded, respectively.  If neither is specified, both are loaded.
NOCONFIRM	Specifies to redefine an existing program unit without prompting you for confirmation.
Comments	The source text is compiled as it is loaded.  If the resulting program unit is a named entity (i.e., a subprogram or package), processing is complete.  If the program unit is an anonymous block, it is executed and automatically discarded upon completion.

If you try to load a program unit with the same name and type as an existing program unit, a message box displays, asking if you want to redefine the existing program unit.  Specifying NOCONFIRM in the command string suppresses the alert.


LOAD (stored program units) command example

  Related Topics 	  All Examples

The following command loads the program units whose source is contained in the files proc1.pls and func2.pls in the current directory:

.LOAD STORED PROG scott.proc1, scott.func2


SHOW (locals) command

  Examples	   Related Topics 	  Alphabetic List

Description	Lists the current local variables and parameters that are defined at the current scope location.

Syntax

SHOW LOCALS

SHOW PARAMETERS

SHOW VARIABLES

Keywords and Values

LOCALS	Specifies all parameters and variables.
PARAMETERS	Specifies all parameters.
VARIABLES	Specifies all variables.


SHOW (locals) command example

  Related Topics 	  All Examples

The following command displays information about all of the current parameters:

.SHOW PARAMETERS


SHOW (program units) command

  Examples	   Related Topics 	  Alphabetic List

Description	Enumerates the program units that are currently defined in the development session.

Syntax

SHOW PROGRAMUNITS
     [USER | BUILTIN]
     [SPECIFICATION | BODY]

SHOW PACKAGES
     [USER | BUILTIN]
     [SPECIFICATION | BODY]

SHOW SUBPROGRAMS
     [USER | BUILTIN]
     [SPECIFICATION | BODY]

SHOW PROCEDURES
     [USER | BUILTIN]
     [SPECIFICATION | BODY]

SHOW FUNCTIONS
     [USER | BUILTIN]
     [SPECIFICATION | BODY]

Keywords and Values

PROGRAMUNITS	Specifies all program units.
PACKAGES	Specifies all packages.
SUBPROGRAMS	Specifies all subprograms.
PROCEDURES	Specifies all procedures.
FUNCTIONS	Specifies all functions.
USER or BUILTIN	Specifies whether to show user-defined or built-in program units, respectively.  The default is USER.
SPECIFICATION or BODY	Dictate whether specifications or bodies are listed, respectively.  By default, both are listed.


SHOW (program units) command examples

  Related Topics 	  All Examples

The following command lists the names and types of all current user-defined program units:

.SHOW PROGRAMUNITS

The following command lists all of the built-in package specifications:

.SHOW PACK SPEC BUILT


Glossary

A

    action
    active window/view
    ActiveX
    Ada
    aggregation
    alert
    alignment
    alias
    All tool
    ancestor
    ancestor group
    anchor
    anchor point
    anonymous block
    antecedent
    applet
    application
    argument
    ASCII
    attached library
    attribute
    attribute columns
    attribute mask
    Attribute tool
    attribute value
    axis chart

 B

    background element
    background process
    baseline value
    Batch
    batch compile
    bind reference
    bind variable
    block
    body
    boilerplate
    border
    bounding box
    break chart
    break column
    break group
    break report
    break trigger
    breakpoint
    builder
    built-in datatype
    built-ins
    built-in macro
    buffer
    button
    button procedure

C

    cache (memory)
    call interface
    call stack
    canvas
    canvas view
    cartridge
    cascading style sheet
    category
    category axis
    cell
    CGI
    CGM
    CHAR datatype
    chart element
    chart item
    chart template
    check box
    checksum
    child
    child query
    classification
    clause
    client
    client/server architecture
    Clipboard
    CMDFILE
    collection type
    color palette
    column
    column object
    command line
    comment
    commit
    comparison operators
    compile
    component
    concurrency
    condition
    confine mode
    connect
    connect string
    constraint
    construct
    context area
    continuous axis
    control point
    coordinate plane
    coordinate system
    coordinates (x, y)
    copy
    correlated subquery
    cross product
    crosstab
    cursor
    custom measure
    cut

D

    damage
    data dictionary
    data link
    data model
    data structure node
    database
    database trigger
    datasource
    datatype
    DATE
    date axis
    debug
    debug action
    debug trigger
    Debugger
    deconstructed object
    default
    deliver
    dependency tree
    dependency view
    dependent data
    descendant
    designer
    Designer (Oracle)
    detail query
    dialog box
    DIANA
    dimension
    dimension hierarchy
    dimension value
    disabled
    discrete axis
    display
    display item
    downward-growing
    drag
    drill
    duplicate
    dynamic saved selection

E

    EBCDIC
    edge
    Edge/Fill/Text Display
    editor
    element
    element type
    Ellipsis button
    enabled
    enclosing object
    encryption
    environment
    exception
    Exception tool
    executable argument
    execute
    export
    export file
    expression
    external PL/SQL library
    external query

F

    family
    Family tool
    field
    field template
    file node
    fill area
    filter
    firewall
    flattened object
    flex mode
    focus
    foreground element
    foreign key
    form layout
    form letter layout
    format mask
    format trigger
    formula
    formula column
    frame
    function

G

    generate
    Generate
    Global Registry
    global variable
    grant
    gridlines
    group
    group filter
    group tree
    GUI

H

    handle
    header
    heading node
    hidden
    hierarchy
    HTML
    HTTP
    hyperlink
    hypertext

I

    ICD
    icon
    image
    implied item
    import
    independent data
    index
    inherit
    inner bounding box
    input item
    insert mode
    internet
    Interpreter script
    intranet
    IP (Internet Protocol) Address
    item
    item node

J

    JAR
    Java
    join
    justification

K

    keyword

L

    label
    Launcher
    level
    Level tool
    layout
    layout unit
    lexical reference
    library
    link
    link file
    list box
    list item
    list of values
    List tool
    local database
    local registry
    local variable
    logical operators
    logical page
    loop

M

    macro
    mailing label layout
    margin
    master/detail layout
    Match tool
    matrix cell
    matrix layout
    matrix report
    measure
    megabyte (Mb)
    message box
    method
    modal window
    modeless window
    module
    multi-line field

N

    NA value
    nested matrix
    NOCACHE
    node
    non-caching column
    NULL value
    numeric operators

O

    object
    object column
    object group
    object handle
    Object Navigator
    object table
    object type
    ODBC
    OLE
    OLE container
    OLE Server
    Oracle datatype
    Oracle Designer
    ORACLE_HOME
    organization node
    origin
    outer bounding box
    overflow

P

    packaged function
    package
    package body
    package specification
    page
    page break
    palette
    pane
    panel
    parameter
    parameter list
    parent
    paste
    pattern
    Pcode
    PDF
    physical page
    placeholder username
    plot type
    PL/SQL
    pld file
    pll file
    pls file
    plx file
    pop-up list
    port
    pre-defined action
    pre-defined type
    preference
    preview
    Previewer
    primary key
    primitive
    printer control code
    prt file
    procedure
    program unit
    project
    project file
    project item
    Project Navigator
    project node
    project registry
    project view
    Project Wizard
    property
    property class
    protocol

Q

    qualifying dimension
    query
    query filter function
    quit

R

    radio button
    radio group
    Range tool
    RC4
    RDBMS
    rdf file
    rep file
    read consistency
    record
    record group
    REF column
    reference line
    refresh
    register
    registry
    relational operator
    remote database
    repeating frame
    replace mode
    report-level objects
    Reports Background Engine (RWRBE60)
    Reports Queue Manager (RWRQM60)
    Reports Server (RWMTS60)
    Reports Web Cartridge
    Reports Web CGI (RWCGI60)
    rex file
    RGB
    root
    root node
    row
    row object
    RTF
    run
    runfile
    Runtime
    Runtime Parameter Form

S

    saved selection
    Saved Selection tool
    schema
    scope
    script
    section
    SELECT statement
    selection
    selection script
    Selector
    Selector tool
    session
    sibling
    socket
    Sort tool
    source
    specification
    split bar
    SQL
    sql file
    SQL script
    SQL statement
    stack
    statement
    static saved selection
    stored program unit
    stored subprogram
    style sheet
    subprogram
    subproject
    subproject node
    summary column
    SYLK
    syntax
    system variable

T

    table
    table type
    tabular
    target
    target node
    TCP
    tear-off menu
    text item
    title bar
    title page
    toggle
    tool
    toolbar
    tool palette
    Top/Bottom tool
    trailer
    transaction
    trigger
    type

U

    update
    URL
    user exit
    user-defined action
    user-defined type
    user-defined macro
    user registry

V

    valid XML
    value axis
    value construct
    variable
    varying array type
    VBX
    VBX control
    view
    virtual directory
    virtual file system
    visual attribute

W

    Web
    Web browser
    Web cartridge
    Web link
    Web server
    well-formed XML
    wildcard
    window
    WKS
    WRB
    WWW

X

    XML

Y

Z

    zoom


In Project Builder, a command string supplied either by Project Builder or by the user that applies to files of a given type.  An action is not restricted to a single file type; for example, if the action "Compile" is defined for both forms and C source files, selecting "Compile Project" will compile all .fmb and .c files using the appropriate tools.  See also:  pre-defined action, user-defined action.


A high-level programming language developed by the U.S. Department of Defense for use in embedded computer systems.


A window or view that can receive user input.


(Oracle Express) The consolidation of data for several dimension values into a single value, such as the total units sold for all the cities, or into a smaller set of values, such as the average units sold for cities in each region. Data is often collected at the lowest level of detail and is aggregated into higher level totals for analysis.


A modal window that notifies you of a condition that occurred because of your last action.  You must respond to an alert.


The way in which data is positioned in a field.  It may be positioned to the left, right, center, flush/left, flush/right, or flush/center of the defined width of a field.


A secondary name used in a SQL statement to reference a table, view, or column.


(Oracle Express) A Selector dialog box tool that allows you to select all of the values in a dimension, or all of the values in a dimension for a specific hierarchy.


(Oracle Express) A dimension value at any level above a particular value in a hierarchy. The ancestor value is the aggregated total of the values of its descendants.  The following example shows the dimension value "Europe" as the ancestor of "France," "Lyon," and "Paris" in the GEOGRAPHY dimension.


A group that owns another group, either directly or indirectly.


A layout object used to fix a spot on one object to a spot on another object, ensuring the position of the first object in relation to the second object.


(Oracle Express) A specific dimension value that is used when selecting dimension values based on their family relationship or when navigating through a hierarchy.


A PL/SQL program unit that has no name and does not require the explicit presence of the BEGIN and END keywords to enclose the executable statements.  Since they are unnamed, anonymous blocks cannot be referenced by other program units.


An object that appears in another object's group tree at any position above that other object.  Every object is an antecedent of its descendants.


A Java term for small programs that can be dynamically imported into Web pages or applications as needed.


One or more program modules used to achieve a specific result.  Applications can be nested within other applications.  For example, an application to control a company's inventory could consist of various Form Builder applications for input of data, and various Graphics Builder applications to display the data visually.


1. An optional expression passed to a program unit for the program unit to operate on.
2. Clauses containing keywords and their specified values.


Acronym for American National Standard Code for Information Interchange.


A read only collection of PL/SQL subprograms, usually provided with an application to supply necessary PL/SQL source.  Program units in an attached library are implicitly loaded when they are first called by another program unit at compile-time or runtime.  They remain loaded for quick reuse, which reduces runtime memory requirements and improves the performance of an application.  See also:  library .


1. See property.
2.  A part or component of an Oracle8 object type definition.  Each attribute has a name and an Oracle8 datatype.  When an object table is created based on the object type, the columns in the table correspond to the attributes in the object type definition.  When a column object in a relational table is created based on the object type, the column object contains the equivalent of sub-columns, each of which corresponds to an attribute in the object type definition.  Each Oracle8 object attribute in a table is treated as a separate data item, as if it were a separate column.  This is true for both object tables and column objects in relational tables.
3. (Oracle Express) A descriptive characteristic that is shared by dimension values. Attributes represent logical groupings that allow users to select data based on like characteristics. For example, in a database representing footwear, you can use a shoe color attribute to select all boots, sneakers, and slippers that share the same color.


The columns that compose a column object (Oracle8).


In Graphics Builder, the first element in an attribute descriptor.  It is a 32-bit mask that informs the toolkit of the attributes that will be set or retrieved by a subsequent function call.  Only those elements that have their corresponding bits set in the attribute mask are set or retrieved.


(Oracle Express) A Selector dialog box tool that allows you to select dimension values based on attributes and attribute values. For example, in a database representing soft drinks, you might select all products whose size is 1 liter. In this example, Size is an attribute and 1 liter is an attribute value.


(Oracle Express) The values in the database that make up an attribute. For example, in a database representing ice cream products, the following attribute values might belong to a flavor attribute in a Product dimension: vanilla, chocolate, and strawberry. Dimension values at various levels in the Product dimension -- brand, form, and size, for instance -- might share the same value for flavor.


A type of chart in which the data is plotted according to where it lies along the chart's edges, called axes.  An axis chart may contain two or three axes, each of which may be one of the following types:  discrete, continuous, or date.


The white part of a pattern.  You apply color to the background element using the Fill Color palette.


A non-interactive process that runs in an operating system environment and performs some service or action.  Certain Oracle products use background processes for different tasks, such as performing and coordinating tasks on behalf of concurrent users of the database, processing and delivering electronic messages, and managing printing services.


The value used as the starting point for plotting fields on the continuous axis of a chart.


The executable that executes an application in batch mode, without using a windowing system.


To translate, at once, several PL/SQL program units into a machine executable form.


A reference to a parameter used to replace a single literal value (e.g., a character string, number, or date) appearing anywhere in a PL/SQL construct or a SQL SELECT statement.  For a bind reference, you must precede the parameter name with a colon (:).


A global variable you can create and use outside of a PL/SQL package.


1. The basic program unit in PL/SQL, defined by the keywords DECLARE, BEGIN, EXCEPTION, and END.
2. In Form Builder, a logical container that relates to a database table or view.


1. Contains the same information as the program unit specification, and also includes the actual implementation of the subprogram (i.e., its sequence of actions).  In most cases, only a body must be defined for a subprogram.
2. In Report Builder, a region that contains the bulk of the report layout (text, graphics, data, and computations).  The report body appears between the report header and trailer pages.


Text and/or graphics that appear in a report every time it is run.  In some products this is called "constant" text or graphics.


A user-defined outline around a layout object, usually used to highlight its contents.  Borders are drawn such that half the width of the border lies outside the edge of the object, and half inside the edge.


See inner bounding box, outer bounding box.


An axis chart that displays two categories of data along one axis.


A query column assigned to a break group.


A group used to break or categorize report data.  All data in query columns assigned to a break group appear above the data in columns belonging to other groups.  Each record fetched for a break group appears only once, while multiple related records in other groups can be displayed.


A report that contains categories that break the report data into sets.


A PL/SQL block that executes each time a breakpoint is reached.  See also:  breakpoint.


A debug action you can place at any executable source line in a PL/SQL subprogram.  A breakpoint interrupts execution of the program unit and passes control to the PL/SQL Interpreter.  Breakpoints allow you to incrementally execute a subprogram and search for runtime errors.  See also:  break trigger.


Refers to a component used to create a specific type of document. For example, Form Builder is used to create forms, while Report Builder is used to create reports.


A datatype defined and supported by the Oracle Server.


A collection of extensions to the PL/SQL language that are designed to be used with the software.  Built-ins include datatypes, procedures, functions, exceptions, and constants.


In Project Builder, macro shipped with Project Builder.  See also:  macro.


A temporary storage area for data during the transfer of that data between the computer and a peripheral, or between parts of a computer.  A buffer prevents loss of information due to differences in the speed or timing of the transfer and speeds up certain functions.


1. An interface element used to select an action item, display a dialog box, or acknowledge the current condition.
2. An object in an application that has a PL/SQL procedure associated with it.  The procedure is generally executed upon a user mouse event.


A PL/SQL procedure associated with an application object, that is executed when a specific mouse event occurs on the item at runtime (e.g. clicking the button).  It does this by establishing a hierarchy for the fetched data containing a break group.


A temporary storage place for database data that is currently being accessed or changed by users, or for data that Oracle Server requires to support users. The terms are often used interchangeably.


An interface that enables you to invoke Forms Developer or Reports Developer component executables from other Oracle products, or a 3GL program.


A chain of subprogram calls, from the initial entry point down to the currently executing subprogram.  Each subprogram call is represented by a frame on the downward-growing call stack, in which newly entered subprograms are added to the bottom of the stack.


   See editor.


In Form Builder, the background object on which you place the interface objects that users will interact with in the runtime application.  A canvas view is usually associated with a window.


Manageable objects that plug in to the client, application server, or database through an open API.


See style sheet.


A label component that allows differentiation between information on the basis of non-hierarchical delineation or compartments rather than sensitivity levels.  With classification, they are used as a means of restricting access to information.


See discrete axis.


An instance of data in a spreadsheet (e.g., Microsoft Excel).


Acronym for Common Gateway Interface. The industry-standard technique for running applications on a Web server.  Whereas standard HTML documents retrieved from a Web server are static (the exact same text is retrieved every time) CGI enables a program running on the Web server to communicate with another computer to generate "dynamic" HTML documents in response to user-entered information.


Acronym for Computer Graphics Metafile.  A file format recognized internationally and used to store and transport object-oriented graphics from one system or program to another.


An Oracle datatype provided for ANSI/ISO compatibility.  A CHAR column is a fixed-length column and can contain any printable characters, such as A, 3, &, or blanks, and can have from 1 to 255 characters or can be null.


A bar, line, symbol, or other graphical object that represents a single value for a field.


A bordered rectangle of any size used to embed Graphics Builder charts in a form or report.


A collection of attributes and properties that defines the format of a chart.


A interface element, appearing as a small square, that a user can toggle on or off.


An error-checking algorithm.


1. An object that is a member of a group, and is immediately below that group object in its group tree.  The objects that compose a group object are children of that group.  Every object is a child of its parent.
2. (Oracle Express) A dimension value at the level immediately below a particular value in a hierarchy. Values of children are included in the calculation that produces the aggregated total for a parent.  A dimension value may be a child for more than one parent if the dimension has more than one hierarchy.  The following example shows the dimension values "Lyon" and "Paris" as the children of "France" in the GEOGRAPHY dimension.


See detail query.


A hierarchical level that denotes the sensitivity of the information that is labeled.  Classifications are used as a means of restricting access to information.


A part of a SQL statement that does not constitute the full statement; for example, a "WHERE clause."


A user, software application, or computer that requests the services, data, or processing of another application or computer (the "server").  In a two-task environment, the client is the user process.  In a network environment, the client is the local user process and the server may be local or remote.


Separation of processing between two CPUs, one acting as the server that provides services in a transaction and the other as the client in the transaction, requesting and receiving services.  All responsibilities of shared data management can be processed by the computer running the database management system while the workstations running the database application concentrate on the interpretation and display of data.


A memory buffer.  An object remains on the Clipboard until you cut or copy another object, or until you quit the application.


A user-defined datatype that describes a data unit made up of an indefinite number of elements, all of the same datatype.  Varying array types and table types are collection types.  (Oracle8)


An argument that allows you to specify a file that contains a set of command line arguments for Forms Developer executables.


Contains all the colors available to the windowing system, the drawing surface, or a window and its views.


1. A vertical space in a database table that represents a particular domain of data.  A column has a column name (e.g., ENAME) and a specific datatype (e.g., CHAR).  For example, in a table of employee information, all of the employees' names would constitute one column.  A record group column represents a database column.
2. In Report Builder, a data model object created automatically for each column expression in a query's SELECT list, or created manually to perform summaries, formulas, or act as a placeholder.


In an Oracle8 relational table or object table, a column whose definition is based on an object type.  The column is a composite, the parts of which correspond to the attributes of the object type.


An operating-system command line.  Most Oracle products can be invoked from a command line using a number of executable arguments.


A language construct for the inclusion of explanatory text in a program, the execution of which remains unaffected.


To make changes to data in the database permanent.  Before changes are stored, both the old and new data exist so that changes can be stored or the data can be restored to its prior state.


(Oracle Express)

>	Greater than

<	Less than

=	Equal to

<=	Less than or equal to

>=	Greater than or equal to

<>	Not equal to

For numbers, the operands are widened to the least common type (Integer is preferred over Long, which is preferred over Single, which is preferred over Double). For Strings, the comparison is case-sensitive and is based on the collating sequence used by the language specified in the Windows Control Panel. The result is 0 for FALSE and -1 for TRUE.


To translate a source program into a binary, executable format.  PL/SQL program units must be compiled before they can be executed.


A specific target object that is a part of a larger application; e.g. a form in an order entry system, or a library that is shared among many other elements.  See also:  target.


The simultaneous access of the same data by multiple users executing different database applications or the same application.  In database software concurrency requires additional logic to ensure that all users see consistent data and that all changes are made in the proper order.


An expression whose value is either true or false, such as X> 100.  For example, you can set a condition in a query when you want the query to display only those rows that evaluate as true in your expression.


Layout editor mode that prevents child objects from being moved or resized on or outside their parent objects.


To log on to a database.  You must connect if you want to create or modify queries or access an application stored in a database.


The set of parameters, including a protocol, that SQL*Net uses to connect to a specific Oracle instance on the network.


A rule or restriction concerning a piece of data (such as a NOT NULL restriction on a column) that is enforced at the database level, rather than the object or application level.


A PL/SQL code structure.  There are two types of constructs: non-value constructs do not return a value; value constructs return a value.


A work area in which Oracle Server stores the current SQL statement, and if the statement is a query, the result's column headings and one row of the result.  Also referred to as cursor.


An axis that plots values that begin with one value and continue until they reach another value.  Thus, these values are mathematically related.  Dependent data is usually plotted along this axis, also called the value axis.


The four corner points of the virtual rectangle that constitutes an object's ideal shape.  When you select an object on the layout, its control points appear.  Depending on the object selected, you may be able to modify it by dragging a control point.


The two-dimensional grid on which drawing takes place.


The type of x, y units used to place and size objects in the Layout Editor view.  The coordinate systems available are 1) character, which uses the platform's native character cell size, and 2) real, which can be in units of pixels, centimeters, inches, or points.


The location points for objects appearing in the layout.  x and y coordinates determine the horizontal (x) and vertical (y) placement of objects.


To store a replica of a selected object on the Clipboard, so that it may be pasted elsewhere in an editor if desired.


A subquery based on the same tables as the parent query (i.e., references columns in the tables included in its parent query).


Group that owns two or more other groups and performs a mathematical cross product (i.e., correlates values between them).


See matrix cell.


1. A small icon representing the position of the mouse.  The shape of the cursor varies, depending on the selected tool.
2. An internal pointer to data retrieved by a query.  A cursor points only to one row of data at a time; however, you can use built-in subprograms to move the cursor to any row in the data set.


(Oracle Express) A formula created by a user, which allows fine-tuning of data analysis. You create custom measures using base measures in the database. For example, if the database contains the existing measure Volume Share, you can use this measure to create a custom measure named Volume Share Year Ago. This custom measure would allow you to look at a product's absolute share from the previous year.


To delete one or more objects and store them in the Clipboard, so that they may be pasted elsewhere in an editor, if desired.


A view is damaged when it is totally or partially occluded by another view.


A set of tables and views owned by the database administrator.  It is a central source of information for Oracle Server and other relational databases.


A data model object used to define a master/detail (parent-child) relationship between a group and a query.


A relational model that defines what data should be fetched from the database, what values should be computed, and how data should be ordered in a report.  Report Builder objects that define the data model are queries, groups, columns, parameters, and links.


A source for data returned by a query, including database objects such as tables, views, synonyms, snapshots, and queries stored as views.


In Project Builder, a node in the Project Navigator denoting a project item that governs the structure of an open project.  For example, the Global Registry node denotes the Global Registry, which contains a list of local registries and a list of global type definitions.


A set of dictionary tables and user tables that are treated as a unit.


A stored PL/SQL block that is implicitly executed when a triggering INSERT, UPDATE, or DELETE statement is issued against the associated table in the database.  See also:  debug trigger.


A standard form of data.  Some common Oracle datatypes are CHAR, VARCHAR2, DATE, NUMBER, LONG, RAW, and LONG RAW.


An Oracle Server datatype.  A date column may contain a date and time between January 1, 9999 BC and December 31, 9999 AD.


An axis that plots date values that begin at one date and continue until they reach another date.


To detect, diagnose, and eliminate runtime errors in programs.


A user-specified event placed in a PL/SQL subprogram, usually for the purpose of troubleshooting runtime errors.


A conditional debug action you can place at any executable source line in a PL/SQL subprogram.  If the specified condition is met, the specified action is taken before execution of the subprogram resumes.  See also:  database trigger.


The Procedure Builder functionality within the software component used for testing and debugging.


In Oracle8, object types and objects are composites, built of parts or attributes.  Forms Developer or Reports Developer treats each part/attribute as an independent, individually-selectable data item.  This treatment results in a deconstructed object (sometimes also known as a flattened object).  The object is not an homogeneous entity within the Developer environment.


A piece of data that depends on other data for its value.  For example, an employee's  years of service may have the value 10, which is dependent upon the value of the employee's name.  Also called value data.


A value supplied by the system when a user does not specify a required command parameter or attribute.


To prepare and provide a completed application for distribution and deployment.


In Project Builder, the mechanism used by Project Builder to determine how to compile files that are referenced in projects.  Items toward the top left of the tree depend on items toward the lower right; so, for example, if a header file is either out of date or more recent than the executable file it is used to build, then the Project Builder will rebuild the executable file, given a Build command.  Dependencies also extend to subprojects.  For example, if a subproject consisting of a function library has been rebuilt, the Project Builder "knows" the dependent project will need to be rebuilt in order to use the updated library functions.  See also:  dependency view.


In Project Builder, shows files in the Project Navigator in the order in which they depend on each other, with project nodes at the highest point in the hierarchy, followed by target nodes, which are followed by buildable components of those targets.  For example, an executable form depends on and will be followed by an .fmb file, which may depend on and be followed by a library used for a USEREXIT procedure, and so on.  See also: project view, target.


1. An object that appears in another object's group tree at any position below that other object.  Every object is a descendant of its antecedents.
2. (Oracle Express) A dimension value at any level below a particular value in a hierarchy. Values of descendants are included in the calculation that produces the aggregated total for an ancestor.  The following example shows the dimension values "France," "Lyon," and "Paris" as descendants of "Europe" in the GEOGRAPHY dimension.


The interface used to design different components of a Forms Developer or Reports Developer application.


See Oracle Designer.


An application modeling, design and generation toolset.  Using Oracle Designer, you can generate forms and menus from module definitions recorded in the Oracle Repository.


When defining a master/detail report, the detail query retrieves all related records for each record retrieved by the master, or parent, query.


A partial screen or window that prompts you to enter information necessary to complete an operation.


An intermediate representation of a program unit, generated by the compiler.  The DIANA includes all of the syntactic and semantic information for a compiled program unit.  In order to compile a reference to a program unit, the compiler must have access to the referenced program unit's DIANA.  For example, if program unit A calls program unit B, the DIANA for B must be available before A can be compiled.


(Oracle Express) A type of database object that is a list of values that provide categories for data. A dimension acts as an index for identifying values of a variable. For example, if you have sales data with a separate sales figure for each month, then the data has a MONTH dimension; that is, the data is organized by month. A dimension is similar to a key in a relational database.

Any item of data within a multidimensional variable can be uniquely and completely selected by specifying one member from each of the variable's dimensions. For example, if a sales variable is dimensioned by MONTH, PRODUCT, and MARKET, specifying "January" for the MONTH dimension, "Stereos" for the PRODUCT dimension, and "Eastern Region" for the MARKET dimension uniquely specifies a single cell in the variable. Thus, dimensions offer a concise and intuitive way of organizing and selecting data for retrieval, updating, and performing calculations.

A dimension can be simple, with values that are single text or integer values, or it can be conjoint, with values that are combinations of values in other dimensions. A composite is not a dimension, but it is a conjoint-like internal object that Express treats like a dimension for the purpose of handling sparse data.


(Oracle Express) One element in the list that makes up a dimension. For example, a computer company might have dimension values in the PRODUCT dimension called "LAPPC" and "DESKPC." Values in the GEOGRAPHY dimension might include "Boston" and "Paris." Values in the TIME dimension might include "MAY96" and "JAN97."


An interface element state that means a menu item, button, etc., cannot be used in the current context; i.e., it does not respond to keyboard or mouse input.


An axis that plots distinct values at fixed intervals.  These values are not mathematically related.  Independent data is usually plotted along this axis, also called the category axis.


A Graphics Builder document containing any combination of charts, images, text objects and shapes.


In Form Builder, an item that stores or displays information that must be fetched or assigned programmatically with PL/SQL.


As it pertains to the call stack, in which newly entered subprograms are added to the bottom of the stack.  The earliest frame, corresponding to the initial program entry point, is at the top of the stack, while the latest frame, associated with the most deeply nested subprogram call, is at the bottom of the stack.


Press and hold down a mouse button while you slide the mouse pointer to a particular location in a window.


(Oracle Express) To navigate up and down through the levels of aggregation in a dimension that has a hierarchy. When selecting dimension values or viewing data, you can expand or collapse a dimension hierarchy by drilling down or up in it. Drilling down expands the view to include child values that are associated with parent values in the dimension hierarchy. Drilling up collapses the list of descendant values associated with a parent value in the dimension hierarchy.

You can click on a plus icon ( [image]) to drill down on (expand) the hierarchy or on a minus icon ( [image]) to drill up on (collapse) the hierarchy.

In the Selector, you can click on the drill icon ( [image]) to display the Drill dialog box so you can select a level of detail for the entire dimension.


An option that allows you to copy objects directly on the layout without affecting the contents of the Clipboard.


(Oracle Express) A saved selection that can have different dimension values each time it is evaluated. The selected dimension values might differ from use to use. In contrast, a static saved selection is an unchanging list of dimension values. A dynamic saved selection script might include "Select the last three Months", while the script for a static saved selection might have "Select February 1996, March 1996, and April 1996".


Acronym for Extended Binary-Coded Decimal Interchange Code.


The boundary of an object.


A display box on the Layout Editor tool palette that shows the current settings for the edge, fill, and text patterns and colors.


A work area in which you perform a specific set of tasks, such as creating a program unit or designing an application.


A thing of significance about which you may need to record information.  Elements are described by attributes and associations to other elements.


Any element held in the dictionary is classified as being of a particular type.  Examples of element type are entity, attribute, program module, table, diagram, text, softbox.  Occurrences or instances of these are called elements.


(Oracle Express) Displays a dialog box related to the task you are performing, usually so you can select one or more values that you need.


An interface element state that means that a menu item, button, etc., can be used in the current context, that is, it responds to keyboard or cursor/mouse input.


An object that contains another object.  An object is considered to be enclosed by another object only if all of the following are true:  both objects belong to the same region (Body, Margin, Header, or Trailer);  the outermost of the two objects is a frame or repeating frame;  the outermost of the two objects is behind the other object;  the innermost of the two objects lies entirely within the borders of the other object.


The practice of scrambling (encrypting) data in such a way that only an intended recipient can unscramble (decrypt) and read the data.


The user's computer-based workplace, including the tools typically used and their configurations. For Project Builder, this refers to the subset of tools that are used to complete various tasks related to developing Forms Developer applications.


A warming or error condition generated from a PL/SQL subprogram.


(Oracle Express) A Selector dialog box tool that allows the user to select dimension values associated with data that meets cutoff terms that the user specifies. For example, the user can select all products whose dollar sales were greater than $10,000 for the week ending December 23, 1995 in the Boston market.


An argument you can pass to a product executable, such as 'OPENFILE=my_disp' and 'PRINT=YES'.  These arguments usually are specified when the executable is invoked from a command line.


See run.


To store a copy of an object, module, selected text or image to a file or database.  In Project Builder, the process of writing out a file containing project, type, action, and/or macro definitions in a portable format for distribution to others who may work on heterogeneous platforms.  See also:  export file, import.


In Project Builder, the shareable, portable file created by exporting a project.


1. A PL/SQL construct combining variables, constants, literals, and operations on their values.
2. (Oracle Express) One or more data values that are specified in an Express language program. For example, you can specify expressions as arguments to programs or functions. An expression can be any of the following:

•	A single, literal value (for example, 10)

•	A variable or formula that contains one or more values

•	A function that returns one or more values

•	A calculation that combines values, such as variables, formulas, or functions, with arithmetic or Boolean operators


See library.


An ANSI-standard SQL SELECT statement that can be referenced by other Oracle products.


(Oracle Express) A group of related dimension values that correspond to the levels of the dimension hierarchy. Dimension values within a family can relate to each other as ancestor, parent, child, and descendant.  The following example shows family relationships for the dimension value "France" in the GEOGRAPHY dimension.


(Oracle Express) A Selector dialog box tool that allows the user to select a family of dimension values for a particular hierarchy. A family includes a parent and all of its descendant dimension values. For example, the user can select all of the family members below the Chicago market level in the Geography dimension.


1. An interface element in which you enter, edit, or delete data.  2. In Graphics Builder or Report Builder, a layout object that define how the data for a specific query column appears.


In Graphics Builder, a collection of attributes and properties that determines how dependent data (values) are represented as chart fields, such as bars or lines.


In Project Builder, a node in the Project Navigator denoting a file stored in the file system.  For example, the global and local registry nodes correspond to global and local registry files.


The area within an object to which a fill (color or pattern) should be applied.


A PL/SQL function or anonymous function that restricts the data displayed by a group.


A computer that regulates access to computers on a local area network from outside, and regulates access to outside computers from within the local area network.


See deconstructed object.


Layout Editor mode that automatically resizes or shrinks parent objects when child objects are moved or resized, and adjusts the positions of other layout objects that might otherwise be affected by the repositioning or resizing of the objects.


The state of an entity that is able to respond to input from the user or the client.  If an entity has the keyboard focus, it can receive events when the user presses a key.  If a drawn view has the drawing focus, it can respond to client routines that affect drawing.


The black part of a pattern.  You apply color to the foreground element using the Edge Color palette.


A value or column in one table that refers to a primary key in another table.


In Report Builder, a default layout style in which labels appear to the left of fields, and each record prints on a separate logical page.


In Report Builder, a default layout style that intermixes boilerplate and fields, wrapping lines at "word" breaks.


(Field Properties)  A setting that defines the appearance of the value of a field.  For example, a format mask is used to specify the display of currency amounts and dates.


A PL/SQL function that allows you to dynamically change the formatting attributes of an object.


(Oracle Express) A type of database object that represents a stored calculation, expression, or procedure that produces a value. A formula provides a way to define and save complex or frequently used relationships within the data without resaving the data itself. Each time you use a formula, Express performs the calculation or procedure that is required to produce the value.


A user-created column that gets its data from a PL/SQL function or expression, a user exit, a SQL statement, or any combination of these.


In Graphics Builder, the part of a chart template that defines the basic structure of a chart, but does not determine the way the data is plotted.
2. In Report Builder, a layout object used to enclose other layout objects and control the formatting, frequency, and positioning of several objects simultaneously.


A PL/SQL subprogram that performs a specified sequence of actions, and then returns a value.  Can reside and execute on the client and the database server.


To save an application to a file or database in a binary format that can be executed by Runtime and Batch executables.


The Form Builder executable used to save an application to a file or database in a binary format.


A Project Builder registry that stores information common to an entire Forms Developer or Reports Developer installation.  This information is restricted to type definitions, and their associated actions and pre-defined or user-defined properties.  The use of the Global Registry is optional; its functions can be performed by individual user registries.  See also: registry, user registry.


A logical container that exists across an application.  When an application uses a global variable, the application maintains the variable until the application is exited, or until another object explicitly removes it.


To give a user access to a module.  Only a module's creator can grant its access to other users.


In Graphics Builder, the lines that separate rows and columns in the Layout Editor.


1. An object that is composed of several other objects.
2. In Report Builder, a data model object that is created automatically to contain all the columns selected by a query, or created by the user to modify the hierarchy of the data appearing in a report;  it is used primarily for creating breaks in a report, as well as for resetting computations.
3. In Project Builder, collections of related items available via submenus off the Launcher.  Groups allow users to set up the Launcher much like the Windows 95 Start menu, with arbitrary "groups" as entries that pop up to reveal other items and/or groups.  For example, a user could define a group named "Project Docs", containing a project schedule, to-do list, component specifications, etc.; some files may be .TXT files, other .DOC files.


A PL/SQL function that restricts the data fetched by a group.


A hierarchical model-similar to a "family tree"-that describes the relationships between group objects and the objects that compose them.


Acronym for graphical user interface. The use of pictures rather than just words to represent the input and output of a program.  Programs with GUIs run under a windowing system (such as  X Windows, Microsoft Windows, Apple Macintosh, and so on).  GUI programs display icons, buttons, and so on, in windows on the screen;  users control the GUI programs mainly by moving a pointer on the screen (typically controlled by a mouse).  Also known as a bitmapped interface.


An internal pointer to an application object.  In order to reference an object in a PL/SQL program unit, you must pass its handle as an argument to the appropriate subprogram.


An optional report region that can contain introductory material for the report, including text, graphics, data, and computations.  The report header appears first, before the body and trailer.


A node in the Object Navigator denoting a type of object which can be contained within or associated with a report.  Selecting a heading node does not select an object in the report.


(Field Properties)  A property that specifies whether Report Builder will suppress the indicated field at its location in the layout.  If Hidden is specified, the field's value will appear only where referenced in text objects (using &fieldname).


(Oracle Express) A means of organizing and structuring data. A hierarchy exists when values within a dimension are arranged in levels, with each level representing the aggregated total of the data from the level below. Some dimensions have multiple hierarchies based on them.

The following example shows a hierarchy based on the GEOGRAPHY dimension, in which dimension values are arranged in five levels. Data at the Customers level is aggregated into the Cities level, which, in turn, is aggregated into the Countries/Areas, Continents/Regions, and Global levels.


Acronym for Hypertext Markup Language.  A tag-based ASCII language used to specify the content and links to other documents on Web servers on the Internet.  End users with Web browsers view HTML documents and follow links to display other documents.


Acronym for Hypertext Transfer Protocol. The protocol used to carry WWW traffic between a WWW browser computer and the WWW server being accessed.


A reference (link) from some point in one document to (some point in) another document or another place in the same document.  A Web browser usually displays a hyperlink in some distinguishing way (in a different color, font or style).  When users activate hyperlinks (by clicking on them with a mouse) the browser displays the target of the link.


A collection of documents containing cross-references which, with the aid of a Web browser, allow readers to move easily from one document to another.


Cross-references which, with the aid of a Web browser, allow readers to move easily from one document to another.


Acronym for interface C definition-a PL/SQL application programming interface to functionality implemented in C.


A graphic representation of a window or tool.


A bitmapped object that can be stored and loaded into an application.  The client cannot modify an imported image.


In Project Builder, a project item, usually the result of automatic generation, that Project Builder recognizes and for which it automatically creates entries in the Project Navigator.  For example, Project Builder can recognize .OBJ files, generated as an intermediate step during the compilation of C source files, and create entries for them in the Project Navigator.  Although resetting the properties of an implied item is of limited use (the next compilation will destroy changes) such items can be useful, as they can be examined via actions such as Edit, View, and Print.  See also: item, action.


1. To read a module from the file system or database, and incorporate it into an application.
2. To read in a file containing project information.


A piece of data that does not depend on other data for its value.  For example, an employee's name may have the value Jones, which is independent of the values of other employee's names or associated data.  Also called category data.


An optional structure associated with a table that is used by Oracle Server to locate rows of the table quickly, and (optionally) to guarantee that every row is unique.


In Project Builder, to obtain information for an action, type, macro, or property definition from an ancestor node in the dependency tree.  If related attributes exist in an ancestor node, they may be inherited.  Thus, filesystem items like forms and documents may inherit action definitions from subprojects, projects, the user registry, or the Global Registry; projects may inherit type definitions from the local or the Global Registry; and so on.


The virtual rectangle that constitutes an object's ideal shape and connects its four control points, regardless of edge thickness or other attribute settings.


The file used to build a target: for instance, an .FMB is the input for an .FMX.  Also called source.


A mode in which each character you enter is inserted at the cursor, pushing the following characters to the right.  The opposite of replace mode.


A worldwide TCP/IP-based network of computers.


A file containing any mixture of PL/SQL source, Procedure Builder commands, and SQL statements.


An internal TCP/IP network, access to which is restricted (via a firewall) to individuals inside the company or organization.  An intranet provides similar services within an organization to those provided by the Internet, but is not necessarily connected to the Internet.  A common example of an intranet is when a company sets up one or more Web servers on an internal network for distribution of information or applications within the company.


A four-part number with no more than three digits in each part that uniquely identifies a computer on the Internet.


In Project Builder, an object in the file system associated with the project, such as a form or a document, pointed to or represented by a node in the Project Navigator.


In Project Builder, an entry in the Project Navigator window, consisting of an icon and a descriptive title.  Nodes point to actual items in the filesystem, such as Form Builder files and documents.  See also: node, item.


Acronym for Java ARchive.  A file used for aggregating many files (Java class files, images, and so on)  into one file.


A computer language that supports programming for the Internet in the form of platform-independent "applets".


Combining data from two (or more) tables in a single SELECT statement.


  See alignment.


1. Part of a command line syntax that must be supplied with a corresponding argument.  2. A required part of a PL/SQL construct.


Text identifying the values or meaning of an application's visual objects.


(Oracle Express) A position in a dimension hierarchy. Each level above the base level represents the aggregated total of the data from the level below. For example, the TIME dimension might have ascending levels such as Month, Quarter, and Year. Within a dimension hierarchy, a dimension value at one level has a family relationship with the dimension values at the levels above and below that level.


(Oracle Express) A Selector dialog box tool that allows the user to select dimension values based on their level in a particular hierarchy. For example, the user can select all of the dimension values at the Key Account level in the Geography dimension.


The area of an editor in which you can create, modify, position, or delete objects.


A unit of measurement for ensuring a consistent measurement system across different display devices.  Used to specify a position on the layout, or the dimensions of an object.


A reference to a parameter used to represent a string of text in a SQL SELECT statement.  For a lexical reference, you must precede the parameter name with an ampersand (&).


A collection of one or more PL/SQL program units that are stored together in a file on the client file system or in the database.  Program units stored in a library can be referenced by several applications at once.  Unlike stored program units, which reside and execute in the database, program units in libraries always load and execute within the PL/SQL engine on the client side.  To reference program units that are stored in a library, you must first attach the library.  See also:  attached library.


A data model object used to define a master/detail (parent-child) relationship between a group and a query.


The name of a file to which a boilerplate object is associated.  At runtime, Report Builder imports the file's contents into your report layout.


A list of items within a dialog box.  Usually, the list box offers choices for selection, and it is scrollable.


In Form Builder, an item that displays a list of choices.


Also called LOV. A scrollable popup window that provides the user with a single or multi-column selection list.


(Oracle Express) A Selector dialog box tool that allows you to select dimension values from a list of the currently selected values in the dimension.


1. The database on the computer running the application.  2. The database to which an application is connected.  This database parses and executes all SQL statements generated by the application.


See user registry.


A PL/SQL variable declared only within the scope of the current program unit.


(Oracle Express)

Not	Unary Not -- Operand can be integer or long. The operation is performed bitwise (one's complement).

And	And -- Operands can be integer or long. The operation is performed bitwise.

Or	Inclusive Or -- Operands can be integer or long. The operation is performed bitwise.

Xor	Exclusive Or -- Operands can be integer or long. The operation is performed bitwise.

Eqv	Equivalence -- Operands can be integer or long. The operation is performed bitwise. (A Eqv B) is the same as (Not (A Xor B)).

Imp	Implication -- Operands can be integer or long. The operation is performed bitwise. (A Imp B) is the same as ((Not A) OR B).


One page of your actual report (it may be displayed on one or more physical pages).


In a PL/SQL subprogram, a conditional statement that is repeated until the condition is no longer met.


In Project Builder, a type-specific variable that may be used to customize and extend actions.  A macro may be either a constant or a simple expression (which, in turn, may contain other constants and/or expressions).  The use of macros adds great flexibility in issuing command options, and in allowing the user to modify sets of commands by changing one property definition.


A default layout that displays records in one or more columns on the page.  Fields appear directly beneath each other in a single repeating frame.


An optional report region that appears at the top and bottom of each logical page in the body region.  The margin may include any layout object, but typically contains boilerplate and fields (for page numbers, page totals, grand totals, and current date and time).


A default layout in which the detail records appear below the master records.  Master records appear in form layout style, while detail records appear in tabular layout style.


(Oracle Express) A Selector dialog box tool that allows the user to select dimension values by matching characters in dimension value names to characters that the user specifies. For example, the user can select all dimension values in the Product dimension at the Brand level that contain the characters "new."


A repeat direction that displays each record of a repeating frame as a cell of a matrix.


A default layout, resembling a grid, that formats the four sets of data necessary for a matrix report; one set of data displays as a row of labels, one as a column of labels, one set creates the grid, and one set fills the cells of the grid.


A cross-tabulation of four sets of data:  one set of data displays across the page; one set of data displays down the page; one set of data is the cross-product, determining all possible locations in which the across and down data relate and placing a cell in those locations; and one set of data displays as the "filler" of the cells.


(Oracle Express) Data that can be examined and analyzed, such as sales or cost data. You can select and display the data in a measure. Measures can be stored as variables or relations, or measures can be calculated by means of formulas.


A unit of memory equal to 1,048,576 bytes (1024 x 1024). Often rounded to one million bytes.


A modal window that notifies you of a condition that occurred because of your last action.  You must respond to a message box.


Executable code attached to an Oracle8 object through its object type definition.


A window that elicits a response from the operator before the application can continue.


An unrestricted window that can have as much functionality as the runtime window manager can support.


1. An object that can be shared by multiple applications.  External queries and PL/SQL libraries are examples of modules.  2. In Form Builder, a major component of an application (i.e., a menu module).


A field in a window or dialog that extends for several lines, allowing you to scroll vertically through the information.


(Oracle Express) A special data value that indicates that data is "not available" (NA). NA is the value of any cell to which a specific data value has not been assigned or for which data cannot be calculated.


Matrix report in which either the across and/or down dimension contains one or more master/detail relationships.  There is no limit to the amount of nesting allowed.


A datatype indicating that the data will be fetched when the page on which it appears is formatted (instead of fetched and cached until formatted).


1.  A specific location in the Object Navigator object hierarchy.  Nodes can be expanded to reveal information about an object, such as cross references to other objects.  2.  In Project Builder, an entry in the Project Navigator.  See also:  item, item node, organization node.


A report column that references a database column of datatype NOCACHE.


The absence of a value.


(Oracle Express)

^	Exponentiation,

-,+	Unary minus and plus,

*, /	Numeric multiplication or division. For division, the result is a double.

\	Integer division. The operands can be integer or long.

Mod	Modulus or Remainder. The operands can be integer or long,

-, +	Numeric addition and subtraction. The + operator can also be used for string concatenation.


1.  An item that can be placed on the layout.  The following are examples of objects:  rectangle, line, ellipse, arc, polygon, polyline, rounded rectangle, freehand, chart, text, symbol, and text field.  2.  In Oracle8, an instance of an object type.  An object can be a row in an object table, or the portion of a row contained in a column object in a relational table.


See column object.


A container for a group of objects, used to provide the ability to copy or reference related objects.


See handle.


The window containing a hierarchical list of objects for the current session.  The list appears in outline form, and enables the user to accomplish several tasks such as creating, editing, renaming, and deleting objects.


In Oracle8, a table whose definition is based on an object type.  Each attribute in the object type becomes a column in the object table.  Each row in the table is an individual Oracle8 object.


In Oracle8, a user-supplied definition or template, upon which objects can be built.  An object type is a composite, whose parts are attributes.  Each attribute has a name and a datatype, and the object type as a whole has a name.  An object type may also include one or more methods.


Acronym for Open Database Connectivity.  A standard for accessing different database systems.  An application can submit statements to ODBC using the ODBC flavor of SQL.  ODBC then translates these to whatever flavor the database understands.  Using the Oracle Open Client Adapter (OCA), an application can access different database management systems in one consistent manner.  This allows an application developer to develop, compile, and ship an application without targeting a specific DBMS.


Object Linking and Embedding.


An application that can store and display OLE objects.


An application that creates OLE objects.


See built-in datatype.


An environment variable that indicates the root directory of Oracle products.


An entry in the Project Navigator, such as "Types", "Projects", "Form Files", etc., used to help organize the Navigator and indicate the filetypes of child items.  It may also correspond to a data structure within certain types of filesystem objects.


Represented in x and y coordinates.  The origin of a view indicates the location of the view on its parent's canvas.  The origin of a canvas indicates the position of drawing on a drawn view.


The smallest virtual rectangle that completely surrounds an object.


When an object's contents cannot fit on the current logical page.  In the event of overflow, some of the contents are moved to the next logical page.


A PL/SQL function provided with the software that can be referenced anywhere within a program unit.


A method of encapsulating and storing related procedures, functions, variables, and other package constructs together as a unit in the database or on the client.  While packages provide the database administrator or application developer organizational benefits, they also offer increased functionality and database performance.  The software provides several built-in packages which contain PL/SQL constructs that can be referenced by client-side program units (e.g., TEXT_IO package).  Several packages are also supplied with the Oracle database server for referencing by stored program units (e.g., DBMS_OUTPUT package).


Includes the actual implementation of the package, which may include private subprograms and datatypes.  The body is optional if the package consists only of declarations.


Declares the public interface to the package-that is, the datatypes and subprograms that can be referenced by other program units.


(Oracle Express) 1. A slice of data included in a report. Additional pages display additional slices of data.

The following figure shows three pages of data.

2. In Express, a page can also refer to a unit of storage in an Express database.


(Oracle Express) A representation of how data selected for a query will appear in your spreadsheet. The page layout shows three edges -- Across, Down, and Page. The edges indicate how the multi-dimensional datacube defined by the query will appear in the two-dimensional spreadsheet. Dimension tiles display the names and positions of the dimensions. A dimension tile on the Across edge indicates that this dimension will appear as a column. A dimension tile on the Down edge indicates that this dimension will appear as a row. A dimension on the Page edge indicates that this dimension will appear in a page box at the top of the results.


A setting that controls whether to move the current object and its children to the next logical page.  You can set page breaks to occur before or after the current object appears in the report output.


An interface element that displays tools, colors, or patterns available in an editor.


A distinct portion of an editor where work is performed, usually resizeable.


The number of physical pages needed to print one logical page.


1. A PL/SQL construct used to pass information to a subprogram.  For example, in the subprogram call MYPROC (x),x is a parameter.  2. In Forms Developer, parameters are used to pass information between components such as Form Builder and Graphics Builder.  3. A variable you can change at runtime.


A group of parameter names and associated values used to pass information between Forms Developer components.


1. An object that is immediately above another object in its group tree.  A group object is the parent to each of the objects that compose it.  Every object is the parent of its children.
2. (Oracle Express) A dimension value at the level immediately above a particular value in a hierarchy. The parent value is the aggregated total of the values of its children.  The following example shows the dimension value "France" as the parent of "Lyon" and "Paris" in the GEOGRAPHY dimension.


To place the contents of the Clipboard (cut or copied objects) at the current cursor location.


A graphical property you can apply to the edge or fill of most objects.


The machine code or instruction list for a compiled program unit.


Acronym for Portable Document Format.  A file format (native for Adobe Acrobat) for representing documents in a manner that is independent of the original application software, hardware, and operating system used to create the documents.  A PDF file can describe documents containing any combination of text, graphics, and images in a device-independent and resolution independent format.


The size of a page that is output by your printer.


The type of element used to plot a field on a chart, such as bar, line, or symbol.


Oracle's proprietary extension to the SQL language.  Adds procedural and other constructs to SQL that make it suitable for writing applications.


A Procedure Builder Interpreter script file.


A PL/SQL library file that contains source code and compiled code. The file can be opened in Procedure Builder for editing.


A text file that contains the PL/SQL source of a single program unit.


A runtime PL/SQL library file that contains executable code only.  The file cannot be opened in Procedure Builder for editing.


A list that pops up when the user performs a particular action.


A number that TCP uses to route transmitted data to and from a particular program.


An action shipped with Project Builder and automatically available to the user via a menu item and/or a toolbar button.  Pre-defined actions include Build, Deliver, and several source control options.  When a pre-defined action is defined for a supported file type, the action is invoked for any selected item of that type when the user calls the action from Project Builder.  See also:  action, user-defined action.


See built-in datatype.


A setting that affects the behavior of the application's interface.


(Oracle Express) View the script that would be generated if you accept the current criteria. In the dialog box for any Selector tool you can preview your selection by choosing the Preview button.


The interface with which you view and scroll through report output online.


A column in a database table whose members consist of unique values that can be used to identify a row in a table.


See built-in datatype.


In a printer definition file, an escape sequence to which you assign a printer code that can be referenced in a report.


A file that contains a printer definition in text (e.g., ASCII or EBCDIC) format.


A PL/SQL subprogram that performs a specified sequence of actions. .  Can reside and execute on the client and the database server.


A PL/SQL code structure that can be independently recognized and processed by the PL/SQL compiler.  Anonymous blocks, subprogram specifications and bodies (procedures and functions), and package specifications and bodies are types of program units.  Program units can reside and execute on the client and the database server.  See also:  stored program unit.


The basic data structure created by Project Builder.  Projects are collections of pointers to all the files you consider part of your application, or otherwise want to group together conceptually.  You can define the editors, compilers, and other tools you use to work with the items contained within a project.  All project information is stored within a project registry.  See also:  project item, project file, export.


In Project Builder, project files are all the files associated with an application.  Project files can be of any type, including forms, reports, displays, 3GL modules, documentation, and test scripts. See also:  project, project item.


In Project Builder, anything for which properties may be defined, including all entities stored under the Projects node, types, actions, and macros. See also: project, project file.


The window containing a hierarchical list of project items for the current session.  The list appears in outline form, and enables the user to accomplish several tasks such as creating, editing, renaming, and deleting objects.  Although only one is visible at any time, the user can choose from two different schema by which to organize the objects.


The top-level node for a project.  It represents or points to the project file.  See also: project, project file.


In Project Builder, the file that stores all the information associated with a project:  files belonging to the project, types, actions, and macros defined for the project, and so on.


The project view shows objects organized by their type, and by their project/subproject relationships.  The projects are organized alphabetically by project file, then alphabetically by category.  See also:  dependency view, project, project file, view.


A dialog that assists the user in accomplishing the steps necessary to create a new project or sub project.


A characteristic of an object that determines the behavior or appearance of that object.


A named object that contains a list of properties and their settings used to globally control the appearance and functionality of objects based on that class.


A string you can enter when connecting to a database or server that allows you to connect to a remote database or server.


(Oracle Express) When you select values for one of the dimensions in a measure, the other dimensions that make up that measure are known as qualifying dimensions.

Suppose your Sales measure is dimensioned by Product, Month, and Geography. If you select the top ten cities based on Sales, you must also specify which product and month you want to consider when you compare Sales values. In this case, Product and Month are the qualifying dimensions.


A SQL SELECT statement that specifies the data you wish to retrieve from one or more tables or views of a database.


A PL/SQL function that, when executed, filters data retrieved by a query.  Only the data that meet the conditions in the function are charted.


An option that terminates the current session and returns the user to the operating system.  On some systems, Quit is Exit.


A control (similar to a check box), appearing in sets of two or more, only one of which may be either "on" or "off" at any given time.


A set of two or more radio buttons, only one of which may be either "on" or "off" at any given time.


(Oracle Express) A Selector dialog box tool that allows the user to select consecutive time periods as dimension values. These time periods can be based on any of the following:

•	A specific number of the most recent time periods

•	A beginning time period and a most recent time period

•	A beginning and ending time period

For example, the user can select dimension values for the range from the week ending November 25, 1996 through the week ending December 30, 1996.


A cipher designed by RSA Data Security, Inc. which can accept keys of arbitrary length, and is essentially a pseudo random number generator with the output of the generator being XORed with the data stream to produce the encrypted data.  For this reason, it is very important that the same RC4 key never be used to encrypt two different data streams.


Acronym for Relational Database Management System.  A database that allows the definition of data structures, storage and retrieval operations, and integrity constraints.  In such a database, data and relations between them are organized in tables.


A file that contains a single report definition in binary format.  .RDF files are used to both run and edit reports.


A file that contains a single report definition in binary format.  .rep files are used solely to run reports; you cannot edit a .rep file.


The ability to query the data throughout a database as of a single point in time.


One row fetched by a SQL SELECT statement.


An internal data structure object with a column/row framework, that belong to the form module in which they are defined.


A type of column that points to data in other column objects or object tables (Oracle8).


A line that appears at a specified value on a chart.


(Oracle Express) Fetch the most recent data from an Express database after query results are displayed in your report. When you open a saved Express query, the results are refreshed automatically.


To add the definition of a type or a new project to either the global or local registry.  Upon being registered, a new type can have actions defined for it, while a new project can have its referenced files identified as specific types, so that actions can be invoked against them.  See also:  registry.


A global and/or user-specific configuration file used to store project definitions and environment information.  See also:  Global Registry, user registry.


A symbol used in search criteria to indicate a comparison between two values, such as the equal sign in "WHERE DEPTNO = 10." Rows in which the comparison results in "true" are returned in the result (fetched), while rows in which the comparison returns "false" are rejected from the result.


A database on a computer other than the local database.  Usually a computer on the same network, but at a different node (i.e., a database that you use through a database link).


A layout object used to display rows of data that are fetched for a group.


A mode in which each character you type replaces the current character at the cursor.  The opposite of insert mode.


The objects that are used to define a report's data model and layout.  Report-level objects are assigned to a single report, and cannot be shared by other reports or other Oracle products. Objects include reports, queries, external queries, external PL/SQL libraries, groups, columns, parameters, links, frames, repeating frames, fields, boilerplate, and anchors.


Available on Windows NT and Windows 95 only, waits for any command lines to run a report, then places that report in its queue to run in the background on the local server.  Typically command lines are received from Form Builder or Graphics Builder via RUN_PRODUCT, or from another report via SRW.RUN_REPORT.  You can also use RWISV60 to submit a report to the Reports Background Engine.


Maintains timestamp and status information about reports managed by the Reports Server.


Available on Windows NT, Windows 95, and UNIX, enables running reports on a remote server.  Queues job requests and allows you to schedule when to run reports.  Use RWCLI60 to send a report to the Reports Server.


Provides an interface between your Web Server and Reports Runtime, enabling you to run reports dynamically from your Web browser.


Provides a connection between a Web Server and the Reports Server.


A file that contains a report definition stored in text (e.g., ASCII or EBCDIC) format.  .REX files are used to port reports from one platform to another. Note that .REX files are no longer required. They are available for backward compatibility.


Refers to the intensities of the red, green, and blue components of a color.


The group object to which all other objects in an application belong.


Top-level node for a project representing user's environment.  May correspond to the user registry or the Global Registry, depending on which registry has been chosen to set defaults.


1. One set of field values in a table; for example, the fields representing one employee in the example table EMP.  2.  To generate a runtime version of an application.


An object in an Oracle8 object table.  Each row in the table is an object.  However, in Forms Developer an object table is deconstructed into individual columns, so that the row object no longer exists as a single entity (only as its separate attributes).


To execute a runtime version of an application or program unit.


Acronym for Rich Text Format.  A non-platform-specific file format based on control words used to represent unformatted text and images in various applications and operating systems.  RTF uses the ANSI, PC-8, Macintosh, or IBM PC character set to control the representation and formatting of a document, both on the screen and in print.


See rep file.


The interface in which users view and interact with a runtime application.


A screen or window appearing optionally at runtime in which a user can modify print options and parameters prior to report execution.


(Oracle Express) A set of dimension values that has been saved either as a list of values or as a script. You can save selections that you build, or your database administrator can create saved selections and make them available to you.

Saved selections are a time-saving feature: each time that you need to re-use a selection, you can simply retrieve a saved selection without having to recreate it.


(Oracle Express) A Selector tool that allows you to retrieve a selection of dimension values that has been saved.


A collection of related database objects, usually grouped by database userid.  Schema objects includes tables, views, sequences, stored program units, synonyms, indexes, clusters, and database links.


The level at, or range in which, an object operates.  For Project Builder:  1.  Describes the range of files affected by Compile and Compile All commands invoked against compilable project items.  2:  Describes the range of files influenced by inheritable definitions.


See SQL script, Interpreter script.


In Report Builder, one of multiple layouts in the same report, each with a different target audience, output format, page layout, page size, or orientation.  For example, a single report can include an executive summary for senior management in one section and also a detailed breakdown for  individual managers in another section.


A SQL statement that specifies which rows and columns to fetch from one or more tables or views.


(Oracle Express) The set of dimension values currently chosen for a dimension, or the script that contains conditions or criteria to specify those values.


(Oracle Express) As shown on various dialog boxes in the Selector, a description of the choices that a user has made in selecting dimension values. It is a translation, in ordinary language, of the Express Language script.


(Oracle Express) A set of tools that you use to choose the dimension values to include, for instance, in a report, table, graph, or dimension list box. For example, you can use the Selector to choose the top 10 cities based on Sales or those cities whose Sales exceeded Quota by 15 percent. The Selector also allows you to sort dimension values and to create and retrieve saved selections.


(Oracle Express) A dialog box or group of dialog boxes that provides a particular way of selecting or sorting dimension values. Each Selector tool is part of the Selector. You can use Selector tools to select dimension values based on their level in the hierarchy, their attributes, the characters in the value name, and so on. You can also use Selector tools to sort the dimension values.


The period between invoking and quitting the executable.


One of two or more objects that have the same parent object in its group tree.  All objects that belong to one group object are siblings.


The combination of an IP address and a port number.


(Oracle Express) A Selector dialog box tool that allows you to rearrange the order of dimension values in a displayed selection. You can sort a selection in ascending or descending order by the following:

•	Alphabet

•	Order in the database

•	Data value

•	Order or level in the hierarchy

•	Time period

You can also sort a selection manually, by dragging and dropping dimension values.


In PL/SQL:  Statements provided in a subprogram or package.  You must have the source code for a program unit before you can compile it into executable form.  In Project Builder:  The input types required to build target types.


Defines only the names, parameters, and return type (applies to functions only) of the subprogram.


A small rectangle at the bottom of the vertical scrollbar and to the left of the horizontal scrollbar in an editor.  Dragging and releasing the mouse button creates a new pane, and divides the scroll bar into separate scroll bars for each pane.


A standard interface for storing and retrieving information in a relational database.  SQL is an acronym for Structured Query Language.


A that contains a query stored in text (e.g., ASCII or EBCDIC) format.


A file containing SQL statements that you can run to perform database administration quickly and easily.  Several SQL scripts are shipped with Oracle products.


A SQL instruction to Oracle.  A SELECT statement is one type of SQL statement.


See call stack.


A PL/SQL construct used for conditional, iterative, and sequential control, and for error handling.  A semi-colon (;) must terminate every PL/SQL statement.


(Oracle Express) A saved selection that contains the same dimension values every time it is evaluated. Static saved selections list the dimension values that are to be selected, rather than the selection criteria. For example, a static saved selection script might include "Select February 1996, March 1996, and April 1996", while the script for a dynamic saved selection might have "Select the last three Months".


A procedure, function, or package that resides and executes in the Oracle database server.


A procedure or function that resides and executes in the Oracle database server.


HTML extensions that provide powerful formatting flexibility in HTML documents.  To view an HTML document that takes advantage of style sheets, display it in a browser that supports style sheets.


A PL/SQL procedure or function.


In Project Builder, a project contained within another project file, rather than being stored in its own file.  See also:  project.


In Project Builder, a node denoting a subproject.  See also:  project, project node, subproject node.


A column, with a type of summary, which computes subtotals, grand totals, running totals, and other summaries of the data in a report, using one of the packaged summary functions provided by Report Builder.


The file format used by the Microsoft Excel program.


The orderly system by which commands, qualifiers, and parameters are combined to form valid command strings.


One of the variables that are provided with Reports Developer (e.g., &Logical Page, DESTYPE).


A named collection of related information, stored in a relational database or server, in a two-dimensional grid that is made up of rows and columns.


A collection type, which defines a data unit made up of an unordered set of elements, all of the same data type.  The corresponding data unit is a single column nested table, the column type of which is a built-in type or an object type.  (Oracle8)


A default layout displaying labels at the top of the page and rows of data underneath the labels.


In Project Builder, any item in the middle of the dependency tree; for example, an executable is a (compile) target for a library; while a library is a target for a group of objects; and an object is a target for a source file.


A node denoting a target.  See also: target.


Acronym for Transmission Control Protocol. The underlying communication protocol for exchanging HTTP requests between clients and Web servers.


A submenu that the user can remove from its source using a mouse or other pointing device and drag to another part of the display screen.


In Form Builder, an item that displays a character string value.


The horizontal area at the top of a window that displays the name of the application or interface element in that window.


See header.


To turn a setting alternately on or off.  For example, you can hide or show the Object Navigator.


An iconic button used to create and manipulate objects in an application.


Collection of iconic buttons that perform product commands.  Usually aligned horizontally along the top, or vertically down the side of a window.


A collection of tools.


(Oracle Express) A Selector dialog box tool that allows the user to select dimension values based on the top x, bottom y, or top x and bottom y data values. For example, the user can produce a dimension selection that contains products whose Volume Sales were among the top 10 percent of products in the Total U.S. for the four-week time period ending December 30, 1995.


A optional report region that can contain closing material for the report, including text, graphics, data, and computations.  The report trailer appears last, following the header and body.


A sequence of SQL statements treated as a single unit.


A PL/SQL procedure that is executed, or "fired," upon a specific event.


A description of a file type, such as a form, a document, etc., containing such information as type name and description. Each description applies to a single file type.  In addition, there are four meta-types: "updtext", which applies to all text files, “updproj” which applies to all project files, “updlink”, which applies to all project links, and "all" which applies to any file type.  Types are the foundation for defining actions and macros.


To change the values for table data, in particular, by altering data values using the SQL command UPDATE, but also by deleting values using the SQL command DELETE or by inserting values using the command INSERT.


Acronym for Uniform Resource Locator. The "address" used to specify a WWW server and home page.  For example:
http://www.acme.com/
which indicates that the host's address is www.acme.com. An URL most often is a filename (possibly with a long path to it and usually with an extension of .HTML, or .HTM (for PC-DOS filenames).


A way in which to pass control (and possibly arguments) from Forms Developer to another Oracle product or 3GL, and then return control (and possibly arguments) back to Forms Developer.


A custom action defined by a Project Builder user.  Such actions may apply to any single file type, or to all file types.  See also:  action, pre-defined action.


See object type.


A custom macro defined by a Project Builder user.  Such macros may be used to modify both built-in actions and user-defined actions.  See also:: macro, built-in macro, action, pre-defined action.


A project file storing configuration information on a per-user basis.  This enables users to customize their individual development environments.  The user registry inherits type information from the Global Registry, and may define new types as well as override aspects of type definitions stored in the Global Registry.  It also stores environment and preference information, such as the user's preferred connection string, UI settings such as "Display Toolbar" and certain general project information such as "Author."  See also:  registry, Global Registry.


See continuous axis.


A PL/SQL code structure that returns a value.  Value constructs include functions and expressions.


A named object that can be assigned a value and whose assigned value may change over time.


A collection type, which defines a data unit made up of an ordered set of elements, all of the same datatype.  The corresponding data unit is a varying array or VARRAY.  The number of elements in a VARRAY (size) is variable.  However, you must specify a maximum size when you declare a varying array type.


Visual Basic extension.  Used as the file extension for special dynamic link libraries distributed on files that contain predefined VBX controls.


A widget, built with the Microsoft Visual Basic language, used to enhance the user interface, obtain user input, and display output  (e.g. sliders, grids, and control knobs).


A virtual table whose rows do not actually exist in the database, but which is based on a table that is physically stored in the database.


A directory mnemonic (essentially a shortcut or synonym) that the virtual file system uses to map files stored in the file system on the host machine.


A mapping that associates the pathnames used in URL to the file system maintained by the host machine's operating system.


The font, color, and pattern properties that you set for objects that appear in your application interface.


See WWW.


A program that end users utilize to read HTML documents and programs stored on a computer (serviced by a Web server).


A program executed on a Web server via the Web Request Broker.


A server process (HTTP daemon) running at a Web site which sends out Web pages in response to HTTP requests from remote Web browsers.


A character used to mean 'any one character' or 'a contiguous set of characters' within a word or phase.


1. A rectangular area of the desktop that contains an application.  Each window has an area where you can interact with the application.  Windows can be opened, resized, moved, reduced to an icon, or enlarged to fill the entire desktop.  2. In Form Builder, an object type you can associate with a canvas view.


The file format used by some spreadsheet programs, such as SQL*Calc, or by Lotus 1-2-3 programs.


Acronym for Oracle Web Request Broker.  Provides a powerful distributed runtime environment for developing and deploying applications for the Web.  The WRB runtime platform enables application developers to write applications that are independent of, and work with a number of, Web servers.


Acronym for World Wide Web.  The network of servers on the Internet, each of which has one or more home pages, which provide information and links to other documents on that and (usually) other servers.


To expand an object to allow more room for editing the contents of the field.


The secondary toolbar docked (by default) to the left of the Project Navigator.  It provides simple organization and application launching abilities.


 the latest version of OLE controls (OCX)


XML output complying with general XML principles such as proper tagging, nesting, and the inclusion of an XML declaration, e.g. <?xml version="1.0" encoding="UTF-8"?>.


A placeholder username enables users to log on to the database using their personal username rather than the Oracle database username (e.g., $user_name@database) when running reports from a Web browser.


Extensible Markup Language -- a metalanguage using SGML to define and structure data. Report Builder supports XML output to enable Web publishing as well as electronic data exchange with third-party applications. You can also use XML to build report definitions that can be merged with other report definitions at runtime or run separately


XML output with structure and element content conforming to a document type definition (DTD). Valid XML is also well-formed.


Interpreter commands examples

  Related Topics 	  All Examples

Bind variable commands examples

Database commands examples

Debug action commands examples

Debugging commands examples

Library commands examples

Load path commands examples

Logging commands examples

Program unit commands examples

Session commands examples


Bind variable commands examples

  Related Topics 	  All Examples

CREATE (bind variable) command

DELETE (bind variable) command


Database commands examples

  Related Topics 	  All Examples

CONNECT

DESCRIBE (tables and views)

GRANT

REVOKE

STORE


Debug action commands examples

  Related Topics 	  All Examples

BREAK

DELETE (debug actions)

DESCRIBE (debug actions)

DISABLE (debug actions)

ENABLE (debug actions)

LIST (debug actions)

SHOW (debug actions)

TRIGGER


Debugging commands examples

  Related Topics 	  All Examples

DESCRIBE (locals)

GO

RESET

SET (SCOPE)

SHOW (call stack)

STEP


Library commands examples

  Related Topics 	  All Examples

ATTACH

CLOSE

COMPILE (libraries)

CREATE (libraries)

DELETE (libraries)

DELETE (library program unit)

DESCRIBE (libraries)

DETACH

EXPORT (libraries)

GENERATE

GRANT

INSERT (library program unit)

LOAD (library program units)

OPEN

RENAME

REVERT

REVOKE

SAVE

SHOW (libraries)


Load path commands examples

  Related Topics 	  All Examples

DELETE (load path)

DESCRIBE (load path)

INSERT (load path)


Logging commands examples

  Related Topics 	  All Examples

DISABLE (logging)

ENABLE (logging)

LOG


Program unit commands examples

  Related Topics 	  All Examples

COMPILE (program units)

DELETE (program units)

DESCRIBE (program units)

DISABLE (compiler options)

ENABLE (compiler options)

EXECUTE

EXPORT (program units)

EXPORT (stored program units)

LIST (program units)

LOAD (program units)

LOAD (stored program units)

SHOW (locals)

SHOW (program units)


Session commands examples

  Related Topics 	  All Examples

DESCRIBE (version)

HELP

INTERPRET