For Windows 95/98 and Windows NT

Form Builder

Using Form Builder

Running Form Builder

Graphics Builder

Using Graphics Builder

Running Graphics Builder

Report Builder

Using Report Builder

Running Report Builder

Procedure Builder

Using Procedure Builder

Running Procedure Builder

Project Builder

Using Project Builder

Running Project Builder

Query Builder

Using Query Builder

Running Query Builder

Schema Builder

Using Schema Builder

Running Schema Builder


Using Form Builder on Windows

Note:  For additional information, refer to your  Release Notes (on your installation CD):  RELNOTES.TXT or RELNOTES.PDF.

Starting Form Builder

To start Form Builder for Windows using a remote connection to an Oracle Server:

On 32-bit Windows platforms (NT, 95, 98):

1	Your PC must be configured for network access.  This may require installation and configuration of additional hardware or software.  If you believe that your PC is not configured for network access, contact your system or network administrator.

SQL*Net must be installed.  See your SQL*Net documentation for more information.

2	Click Start [image] Programs [image] Oracle Forms Developer from the Taskbar.

3	Click Form Builder.

Database Connection Errors

If you receive an error in the ORA-3100 to ORA-3199 range when you try to log on to the Oracle server, there may not be enough real-mode memory to establish a connection with an ORACLE database.

NETINIT7.EXE solves this problem by reserving memory for server connections.  NETINIT7 uses the configuration parameter, WIN_REMOTE_SESSIONS, to determine how much real-mode memory to reserve for connections to the server.

Directories

The FORMS60 directory contains the following subdirectories:

Name	Contents
\API	Form Builder API files
\PECS	Performance Event Collection files
\USEREXIT	Sample user exit application
The TOOLS directory contains several modules of general interest in the following subdirectories:

Name	Contents
\COMMON60	Message files, resource files, font aliasing files, color palettes, and other files common to all the  components.
\DBTAB60	Database tables.  Contains one subdirectory, \FORMS60, that contains Form Builder-specific tables.
\DEVDEM60	All the files used in the demos.
\DOC60	Online help, cue card, and Quick Tour files.
\OPEN2K60	ODBC files and source control information.


Running Form Builder under Windows

This topic describes aspects of Form Builder that are specific to its use under Microsoft Windows.

Executables

Form Builder for Windows includes the following executables, located in ORACLE_HOME\BIN:

•	Form Builder (IFBLD60.EXE)

•	Forms Runtime (IFRUN60.EXE)

•	Forms Compiler (IFCMP60.EXE)

You can click Start [image] Run from the Taskbar to run a Forms executable and include command-line options.

Support for System Editors

Form Builder for Windows allows you to invoke a text-based editor to edit multi-line textual information in both the builder and runtime components.

Trigger Limit

Form Builder for Windows supports a maximum of 2048 user-defined triggers per form.

LONG Datatype Limit

Form Builder for Windows supports a maximum size of 64K for the LONG datatype.

Using Ctrl+C

To be able to use the Ctrl+C key sequence to exit out of a long-running query, you must add the following configuration parameter to your configuration file:

CNTL_BREAK=ON

Host Command

The Host command allows you to launch an application synchronously from Form Builder.

If you want to launch an application asynchronously, use the RUN_PRODUCT built-in to invoke another supported Oracle tool.  Use DDE.App_Begin to launch any other Windows application asynchronously.

Icons

Icons are used in Form Builder for iconic buttons and windows (refer to the product documentation for more information).  You can create icons using third-party icon design programs.  Icons are platform-specific and are not portable.

Note:  When setting the Icon Name property for your iconic buttons and windows, do not include the .ICO extension.  For example, enter MY_ICON, not MY_ICON.ICO.

Default Font

The default font is used as the initial font for boilerplate text added in the Layout Editor.  (The font used for text items depends on Visual Attribute settings.)  It is also used to define the width and height (in pixels) of a character cell grid for a form using the "Default Font Scaling" option.

If you specify a monospaced default font, that font will be used for boilerplate text.  If the default font is not a monospaced font, Form Builder will substitute the monospaced font that most closely resembles the font specified.

Using Beveled Controls

When the Use 3-D Controls form-level property is set to True, all items are displayed with a 3-D, beveled appearance and any canvas-view with the Visual Attribute Name set to Default will automatically be displayed with a gray background color.

Oracle Terminal Resource File

The resource file containing Oracle Terminal definitions is FMRUSW.RES, located in the ORACLE_HOME\FORMS60 directory.  Refer to the Oracle Terminal User's Guide for more information on resource files and how to modify the FMRUSW.RES file to suit your needs.

Form Builder Key Assignments

Form Builder provides lists of key assignments for the following tools:

•	Object Navigator

•	Properties window

•	Layout Editor

•	dialog boxes

•	Menu Editor

Choose Help [image] Keyboard Help to display this list of key assignments online.

Object Navigator and Properties Window Keys

The following key assignments apply to the Form Builder for Windows Object Navigator and Properties window:

Function	Key
Cancel	Esc
Collapse All	Ctrl+Left
Collapse One Level	Left
Create Object	Ctrl+Insert
Delete Object	Ctrl+Delete
Down One Level	Shift+Right
Exit	Alt+F4
Expand All	Ctrl+Right
Expand One Level	Right
Expand/Collapse	Enter
First Line	Home
Help	F1
Last Line	End
Next Line	Down
Next Line (Same Level)	Shift+Down
Previous Line	Up
Previous Line (Same Level)	Shift+Up
Show Keys	Ctrl+K
Up One Level	Shift+Left
Layout Editor Keys

Key assignments for the Layout Editor are a subset of the keys listed above.

Dialog Keys

The following key assignments apply to the Form Builder for Windows dialog boxes:

Function	Key
Cancel	Esc
Delete Element	Ctrl+<
Down	Down
Exit	Alt+F4
Help	F1
Insert Element	Ctrl+>
Next Item	Tab
Next Record	Page Down
Previous Item	Shift+Tab
Previous Record	Page Up
Show Keys	Ctrl+K
Switch Elements	Ctrl+/
Toggle Insert/Replace	Insert
Up	Up
The following key assignments apply to the Form Builder for Windows Menu Editor:

Function	Key
Cancel	Esc
Create Down	Ctrl+Down
Create Menu Item	Ctrl+Insert
Create Right	Ctrl+Right
Delete Item	Ctrl+Delete
Exit	Alt+F4
Expand/Collapse	Enter
Expand/Collapse All	Shift+Enter
Help	F1
Into Submenu	Right
Next Item	Down
Out of Submenu	Left
Previous Item	Up
Show Keys	Ctrl+K
Forms Runtime Key Assignments

The following key assignments apply to the Forms Runtime window:

Function	Key
Accept	F10
Block Menu	F5
Cancel	Esc
Clear Block	Shift+F5
Clear Form	Shift+F7
Clear Item	Ctrl+u
Clear Record	Shift+F4
Count Query Hits	Shift+F2
Delete Backward	Backspace
Delete Record	Shift+F6
Display Error	Shift+F1
Down	Down
Duplicate Item	F3
Duplicate Record	F4
Edit	Ctrl+e
Enter Query	F7
Execute Query	F8
Exit	Ctrl+q
Help	F1
Insert Record	F6
List of Values	F9
List Tab Page	F2
Next Block	Ctrl+Page Down
Next Item	Tab
Next Primary Key	Shift+F3
Next Record	Page Down
Next Set of Records	Ctrl+>
Previous Block	Ctrl+Page Up
Previous Item	Shift+Tab
Previous Record	Page Up
Print	Shift+F8
Refresh	Ctrl+P
Return	Enter
Show Keys	Ctrl+F1
Toggle Insert/Replace	Insert
Up	Up


Using Graphics Builder on Windows

Note:  For additional information, refer to your Release Notes (on your installation CD):  RELNOTES.TXT or RELNOTES.PDF.

Starting Graphics Builder

To start Graphics Builder for Windows using a remote connection to an Oracle Server:

On 32-bit Windows platforms (NT, 95, 98):

1	Your PC must be configured for network access.  This may require installation and configuration of additional hardware or software.  If you believe that your PC is not configured for network access, contact your system or network administrator.

SQL*Net must be installed.  See your SQL*Net documentation for more information.

2	Click Start [image] Programs [image] Oracle Forms Developer from the Taskbar.

3	Click Graphics Builder or Graphics Runtime.

Database Connection Errors

If you receive an error in the ORA-3100 to ORA-3199 range when you try to logon to the Oracle Server, there may not be enough real-mode memory to establish a connection with an Oracle Server.

NETINIT7.EXE solves this problem by reserving memory for server connections.  NETINIT7 uses the configuration parameter, WIN_REMOTE_SESSIONS, to determine how much real-mode memory to reserve for connections to the server.

Directories

The GRAPH60 directory contains the following subdirectories:

Name	Contents
\GWIZ_BMP	The bitmaps used by the Chart Wizard
\GWIZ_OGD	The template chart used by the Chart Wizard
\SQL	SQL scripts
\USEREXIT	Sample user exit application
The TOOLS directory contains several modules of general interest in the following subdirectories:

Name	Contents
\COMMON60	Message files, resource files, font aliasing files, color palettes, and other files common to all the components.
\DBTAB60	Database tables.  Contains one subdirectory, \GRAPH60, that contains Graphics Builder-specific tables.
\DEVDEM60	All the files used in the demos.
\DOC60	Online help, cue card, and Quick Tour files.
\OPEN2K60	ODBC files and source control information.


Running Graphics Builder under Windows

This topic describes aspects of Graphics Builder that are specific to its use under Microsoft Windows.

Executables

Graphics Builder for Windows includes the following executables, located in ORACLE_HOME\BIN:

•	Graphics Builder (GOBLD60.EXE)

•	Graphics Runtime (GORUN60.EXE)

•	Graphics Batch (GOBAT60.EXE)

You can click Start [image] Run from the Taskbar to run a Graphics executable and include command-line options.

For information on command-line options, see "About executables" in the Graphics Builder online help.

(Form Builder Only):  Shutting Down Graphics Builder Batch

When Graphics Builder is invoked from a Form Builder application, the Graphics Builder Batch icon appears on your Windows desktop.  You may notice that, after you exit Form Builder, Graphics Builder Batch remains active.  This is to avoid the cost of restarting Graphics Builder Batch for each subsequent call to Graphics Builder.

To shut down Graphics Builder Batch automatically when you exit Form Builder, you can create a Post-Form trigger that tells Graphics Builder to quit.  Use the OG.INTERPRET procedure within the form to instruct Graphics Builder to execute the built-in procedure OG_QUIT, as in the following example.

/* Post-Form trigger */
  OG.INTERPRET('display.ogd', 'CHART_ITEM2', 'og_quit;');

User Exits

A user exit is a subroutine, written in the C programming language, that contains embedded SQL commands.  After you write the user exit, you can link it into Graphics Builder Runtime using a Windows Dynamic Link Library (DLL).  You should be familiar with the procedure for building Windows DLL files as described in your Microsoft C compiler manual.

Warning:  If you are upgrading applications that include user exits and user-created .dll's, the .dll files may need to be recompiled after regenerating your display.

When you install Graphics Builder for Windows, the following files, with the exception of OGXTB60.DLL, are copied to the \USEREXIT subdirectory.

Name	Contents
OGXTB60.DLL	is a sample .dll.  During installation, OGXTB60.DLL may be copied to the ORACLE_HOME\BIN subdirectory.
OGXTB60.DEF	contains module definitions you will need to build your own .dll.
UE.H	contains necessary user exit definitions.
UEZ.OBJ	is an internal Graphics Builder .OBJ file required in OGXTB60.DLL.
UE_XTB.C	is a sample user exit table that you may modify to create an IAPXTB table.  (Refer to Step 2 under "Linking User Exits" below)
UE_XTB.OBJ	is the .OBJ file associated with the UE_XTB.C file.
UE_XTBN.C	is an empty sample user exit table.  You may use this file instead of the UE_XTB.C file to create an empty IAPXTB table.  (Refer to Step 2 under Linking User Exits )
UE_XTBN.OBJ	is the .OBJ file associated with the UEXTBN.C file. You may link this .OBJ file to your own .OBJ files.
UE_SAMP.PC	contains a user exit that exercises EXEC TOOLS.  It demonstrates the interaction between a user exit and a Graphics Builder display.  For more information, see the comments within the file itself.
UE_SAMP.C	is the compiled file from UE_SAMP.PC.
UE_SAMP.H	contains necessary definitions for the sample user exits.
UE_SAMP.OBJ	is the .OBJ file associated with the UE_SAMP.C sample user exit file.
Note:  The sample does not automatically set up INCLUDE paths for the compiler.

Linking User Exits

Complete the steps below to link user exits to Graphics Builder.

1	Write and compile your user exits.

Note:  When compiling your user exits, be sure to specify the LARGE memory model of your C compiler and use FAR argument pointers only.  Refer to your third-party C compiler documentation for more information.

For more information about writing user exits, see "About user exits" in the Graphics Builder online help.  Refer to your Windows compiler documentation for additional information, such as restrictions on building a Windows DLL, and the use of #define statements.  (Your user exit code may need to include the UE.H file to access typedefs and #define statements.)

Note:  If you embed SQL statements in your user exits to access the Oracle Server, you must use Pro*C for Windows to precompile your user exit.  Refer to your Pro*C documentation for information necessary for precompiling user exits.

2	Create IAPXTB, a user exit table, using the UE_XTB.C sample file as a template.  Alternatively, you may create the IAPXTB table using the GENXTB program.  The GENXTB program can be used to create the IAPXTB table and to read the information in the IAPXTB table to create the entry point file needed to link your user exits.  For more information on GENXTB, see "Creating the IAPXTB table" in the Graphics Builder online help.

3	Use the OGXTB60.DEF file to link your objects with the Oracle object file, UEZ.OBJ.

You may also add other files to this link script as needed.  The Oracle libraries SQLLIB18.LIB and SQXLIB18.LIB (for both Windows 95/98 and Windows NT) must be linked if you have embedded SQL statements in your user exit and have precompiled your application.

4	After completing the link, you will need to resource compile your resulting .dll.  For example, the following command uses the Microsoft Windows Resource Compiler to compile the .dll with options:

c> rc -t OGXTB60.dll

5	Make a backup copy of the .dll file in your ORACLE_HOME\BIN directory.  Then copy the new .dll that you just created over the one found in ORACLE_HOME\BIN .

Your user exit is now ready.

Updating Displays

1	To update displays you have created with Graphics Builder for Windows version 2.5.3 or earlier, you must recompile the PL/SQL.  You can do this for multiple displays at once by using command line arguments to open and save the displays.

Click Start [image] Run from the Taskbar.

2	In the Run dialog box, type the complete command line or run a batch file that contains one or more command lines.  For example, type the following command line (do not include carriage returns):

C:\orant\bin\G60BLD userid=scott/tiger
openfile=(disp1.ogd,disp2.ogd)
savefile=(disp1.ogd,disp2.ogd) quit=yes

where C:\orant\bin\G60BLD is the path to the Graphics Builder executable, scott/tiger is the database logon ID, and disp1.ogd and disp2.ogd are the displays.

Note:  Microsoft Windows places a 128-character limit on the text field in the Run dialog box.

3	Click OK to recompile the PL/SQL and update the displays.

OG_HOST

Note that the behavior of the command OG_HOST differs between 16-bit and 32-bit Windows platforms.  On Windows 3.x, if OG_HOST is used to invoke another application, subsequent OG_HOST calls to that application will bring the already-invoked instance to the foreground.  On Windows 95/98 and Windows NT, subsequent calls to an previously-invoked application will result in another instance of that application being started, if that application is capable of multiple instances.

Video Drivers

The Microsoft Windows VGA monochrome video driver may not work with some image files.  Loading some images may cause an unexpected exit when using this video driver or other monochrome video drivers.  Contact Microsoft Corporation for more information.


Using Project Builder on Windows

Note:  For additional information, refer to your Release Notes for Windows (on your installation CD): RELNOTES.TXT or RELNOTES.PDF.

Starting Project Builder

To start Project Builder for Windows:

On 32-bit Windows platforms (NT, 95, 98):

1	Your PC must be configured for network access.  This may require installation and configuration of additional hardware or software.  If you believe that your PC is not configured for network access, contact your system or network administrator.

Note:  Project Builder does not require a connection to an Oracle Server.  However, the remaining components do, and to establish a connection, SQL*Net must be installed.  See your SQL*Net documentation for more information.

2	Click Start [image] Programs [image] Oracle Forms Developer from the Taskbar.

3	Click Project Builder.

Database Connection Errors

If you receive an error in the ORA-3100 to ORA-3199 range when you try to logon to the Oracle Server, there may not be enough real-mode memory to establish a connection with an Oracle Server.

NETINIT7.EXE solves this problem by reserving memory for server connections.  NETINIT7 uses the configuration parameter, WIN_REMOTE_SESSIONS, to determine how much real-mode memory to reserve for connections to the server.

Directories

The PJ60 directory contains several files necessary for Project Builder, including the Global Registry and the default user registry file (typesnn.upd and pjusernn.upd, where nn indicates the national language).

The TOOLS directory contains several modules of general interest in the following subdirectories:

Name	Contents
\COMMON60	Message files, resource files, font aliasing files, color palettes, and other files common to all the components.
\DBTAB60	Database tables.  Contains one subdirectory, \GRAPH60, that contains Graphics Builder-specific tables.
\DEVDEM60	All the files used in the demos.
\DOC60	Online help, cue card, and Quick Tour files.
\OPEN2K60	ODBC files and source control information.


Using Report Builder on Windows

Note:  For additional information, refer to your Release Notes (on your installation CD):  RELNOTES.TXT or RELNOTES.PDF.

Starting Report Builder

To start Report Builder for Windows using a remote connection:

On 32-bit Windows platforms (NT, 95, 98):

1	Your PC must be configured for network access.  This may require installation and configuration of additional hardware or software.  If you believe that your PC is not configured for network access, contact your system or network administrator.

SQL*Net must be installed.  See your SQL*Net documentation for more information.

2	Click Start [image] Programs [image] Oracle Reports Developer from the Taskbar.

3	Click Report Builder.

Database Connection Errors

If you receive an error in the ORA-3100 to ORA-3199 range when you try to log on to the Oracle server, there may not be enough real-mode memory to establish a connection with an ORACLE database.

NETINIT7.EXE solves this problem by reserving memory for server connections.  NETINIT7 uses the configuration parameter, WIN_REMOTE_SESSIONS, to determine how much real-mode memory to reserve for connections to the server.

Directories

The REPORT60 directory contains the following subdirectories:

Name	Contents
\ADMIN	Contains the predefined template files.
\OCI	Contains files for the Oracle Call Interface.
\PRINTERS	Contains printer drivers.  These are only necessary when printing reports on character mode devices.  You do not need them to print on Windows.
\SQL	Contains SQL scripts for building and maintaining Report Builder tables.
\USEREXIT	Contains files you need to build a user exit for Report Builder and example user exit.
The TOOLS directory contains several modules of general interest in the following subdirectories:

Name	Contents
\COMMON60	Message files, resource files, font aliasing files, color palettes, and other files common to all the components.
\DBTAB60	Database tables.  Contains one subdirectory, /REPORT60, that contains Report Builder-specific tables.
\DOC60	Online help, cue card, and Quick Tour files.
\OPEN2K60	ODBC files and source control information.


Running Report Builder Under Windows

This topic describes aspects of Report Builder that are specific to its use under Microsoft Windows.

Executables

Report Builder for Windows includes the following executables, located in ORACLE_HOME\BIN:

•	Report Builder (RWBLD60.EXE)

•	Reports Runtime (RWRUN60.EXE)

•	Reports Convert (RWCON60.EXE)

•	Reports Background Engine (RWRBE60.EXE)

•	Reports Server (RWMTS60.EXE)

•	Reports Web Cartridge (RWOWS60.DLL)

•	Reports CGI (RWCGI60.EXE)

•	Reports Queue Manager (RWRQM60.EXE)

•	Reports Launcher (RWSXC60.EXE)

•	Reports ActiveX Control (RWSXA60.OCX)

You can click Start [image] Run from the Taskbar to run a Reports executable and include command line options.

Parameter Values with Spaces from the Command Line

If you want to pass parameter values with spaces to Report Builder from the command line, you can do it in one of two ways:

•	Specify the parameter name and value in a command file.  For example, suppose that you have a parameter that supplies a query's WHERE clause at runtime.  To pass the value WHERE DEPTNO = 10 from the command line at runtime, create a command file containing the following:

parameter_name='WHERE DEPTNO = 10'

Then, reference the command file via the CMDFILE command line argument (e.g., RWRUN60 CMDFILE=cmdfile_name).

•	Place double quotes (") around the parameter value on the command line.  For example:

DEPTNO="My Department"

Parameter Values with Spaces from RUN_PRODUCT

If you want to pass parameter values with spaces to Report Builder from Form Builder via RUN_PRODUCT, you may need to add extra quotes to delimit the strings in your PL/SQL within your form.  For example, if you want to pass "HP Laserjet 4P", as a DESNAME printer parameter to your report, the PL/SQL in your form may look like this:

printername := '"'||'HP Laserjet 4P'||'"';
add_parameter(plid, 'DESNAME', TEXT_PARAMETER, printername);
RUN_PRODUCT( REPORTS, rptname, ASYNCHRONOUS, RUNTIME,
FILESYSTEM, plid);

MAPI Support

MAPI support enables you to send your report output via electronic mail to other users on your system. Bitmapped (default) reports are sent as email attachments in encapsulated PostScript format.  Character-mode reports are sent as ASCII text attachments.  Refer to the Report Builder online help for details about emailing your reports.

Prerequisites:  You must have an appropriate MAPI mail client application, such as Microsoft Exchange, installed.  For further information, see your operating system documentation to learn how to configure your machine for email capability.

Memory

Some Report Builder system parameters (e.g., LONGCHUNK and BUFFERS) specify an amount of memory for Report Builder to use when running a report.  You should take care not to specify an amount for these parameters that will take up too much of the memory resources on your PC.

OLE2

To control OLE2 behavior in Report Builder, you can set the values of the following parameters in your configuration file:

•	OleCreateObjPoolAlways

•	OleCreateObjPoolInMemory

•	OleDoNotUpdateLinks

•	OleUpdateLinksPrompt

If you do not set the values in the configuration file, Report Builder sets them by default.  In most cases, the default values provide the desired OLE2 behavior.

Non-Blocking SQL

The keyword NONBLOCKSQL=YES|NO has been added for the Builder and Runtime executables.  This keyword enables you to turn non-blocking calls on or off.  Non-blocking calls allow you to continue with other work while data is being fetched from the database and being formatted on the client.  You can also set non-blocking from the Runtime Settings tab of the Preferences dialog box (Tools [image] Preferences).

Non-blocking supports queries in your data model, SQL executed via SRW.DO_SQL, and SQL executed within PL/SQL.  SQL in user exits and the following triggers is not non-blocking:

•	Before Parameter Form Trigger

•	Validation Trigger

•	After Parameter Form Trigger

•	After Report Trigger

Note:  Non-blocking SQL is supported only when using SQL*Net Version 2.1 and later.

Command Line

The length of input on the command line is limited to 128 characters. To work around this limit, use the CMDFILE command line argument.

Tracing

Performance statistics for tracing are not written until after you end your Report Builder session.

Support for System Editors

Report Builder for Windows does not support system editors.

Video Drivers

Report Builder supports video on Windows.  Note, however, that the Microsoft Windows VGA monochrome video driver may not work with some image files.  Loading some images may cause an unexpected exit when using this video driver or other monochrome video drivers.  Contact Microsoft Corporation for more information.

Running Report Builder in the Background

If you specify BACKGROUND=YES when you run a report, the report will be placed in the Reports Background Engine queue.

Running Report Builder in Batch

When running with BATCH=YES, you must specify a file for errors.  Use LOGFILE for Reports Convert, and ERRFILE for Reports Runtime.  Otherwise, the executables will not run.

Call Interface

Database connections can be inherited by Report Builder when it is called through the call interface and it is a part of the same process as the calling application.  However, on Windows, the calling application and Report Builder are always run as separate processes.  As a result, Report Builder cannot inherit the database connection through the call interface.

On Windows, the call interface relies on system call to transfer control to the Report Builder executable.  Error codes returned by the system are passed to the calling application unaltered.  Refer to your Microsoft Windows documentation for information about these error codes.

Terminal Definitions

Terminal definitions are not necessary for Windows.  Printer definitions are set at runtime via DESFORMAT on the command line or Runtime Parameter Form, or Destination Format in Tools Options:Runtime Settings (Tools [image] Tools Options).

Printing Reports

Report Builder for Windows allows you to print to any printer type supported by Microsoft Windows.

Choosing a Printer Dynamically at Runtime

The print device can now be set at runtime. Use the following settings for the runtime parameters when launching reports from Form Builder, Graphics Builder, or any Windows batch utility (e.g. Winbatch):

Destination Type	Printer	File
Destination Name	printer name	file name
Destination Format	not required	printer name or printer definition file (for character-mode reports)
Examples

The following examples show how you can specify the print device at runtime on Windows 95:

•	HP/PCL output to file:

RWRUN60 MODULE=report.rdf USERID=scott/tiger DESTYPE=file DESFORMAT='HP LaserJet IIID'  DESNAME=filename

•	PostScript output to printer:

RWRUN60 MODULE=report.rdf USERID=scott/tiger DESTYPE=printer DESNAME='HP LaserJet IIIP Postscript, LPT2:'

Note: DESFORMAT is not used since the printer specified by DESNAME defines all information about how to format the output.

•	ASCII output to file:

RWRUN60 MODULE=report.rdf USERID=scott/tiger DESTYPE=file MODE=character DESFORMAT='wide' DESNAME=filename

•	ASCII output to printer:

RWRUN60 MODULE=report.rdf USERID=scott/tiger DESTYPE=printer MODE=character DESFORMAT='wide' DESNAME='HP LaserJet IIID, LPT1:'

Notice how DESFORMAT is used based on the value of MODE. If a character report is run, DESFORMAT denotes the printer description file used for the character formatting.  When MODE=bitmapped, DESFORMAT is not used.

It is also possible to print reports to two or more printers using the same printer driver:

•	HP/PCL Output on LPT1:

RWRUN60 MODULE=report.rdf USERID=scott/tiger DESTYPE=printer DESNAME='HP LaserJet IIID, LPT1:'

•	HP/PCL Output on LPT2:

RWRUN60 MODULE=report.rdf USERID=scott/tiger DESTYPE=printer DESNAME='HP LaserJet IIID, LPT1:'

If the connected device (LPT2:) is not specified (e.g., DESNAME='HP LaserJet IIID'), Report Builder will pick the first entry in the available printer drivers with the given printer driver name.


Running Project Builder under Windows

This topic describes aspects of Project Builder that are specific to its use under Microsoft Windows.

Executable

Project Builder for Windows includes the following executable, located in ORACLE_HOME\BIN :

UPC60.EXE

You can click Start [image] Run from the Taskbar to run a Project Builder executable and include command-line options.

For information on command-line options, see "PJ60" in the Project Builder online help.

Creating action for use on Windows

As you create your actions and macros, remember that the syntax of your commands is governed by your platform.  Porting such actions to a different platform will require that the syntax be modified to conform to the rules for the new platform.  Possible conflicts include but are not limited to filename lengths, case sensitivity, and forward and backward slashes.  For more information about syntax requirements on Windows, see your Windows documentation.

Using the Windows shell default commands in actions

An action may be declared as a normal command line (as most of our actions are), or it may be declared as the following:

[open {n}]

or:

[print {n}]

where {n} is the Project Builder built-in macro signifying the fully-qualified name of the file you wish to act on.  The first action runs the Windows shell's default open command on the file; the second, the default print command.  If other commands are registered for a type in the Explorer, you can also use those commands in your action:  for instance, if you have a play action defined for a video file, you can define a Project Builder action like the following:

[play {n}]

on the video file type.

Using DOS commands, pipes, or redirects in actions

In order to use DOS commands, pipes, or redirects in actions, you must first bring up the DOS command interpreter.  For example, on Windows 95 the action:

c:\windows\command /k dir

will bring up a DOS window and execute the dir command.

On Windows NT the DOS command interpreter is named cmd and the previous action can be called with the following::

c:\winnt\cmd /k dir

A more useful example is the following action:

c:\windows\command /c copy {n} {d}\{b}.bak

which makes a backup of your file.

Since you can bring up a DOS command interpreter, you can put pipes and redirects as part of the command.  For example, the following two-line command:

c:\windows\command /c echo {cdebug} {cflags} {cdefs} {cincludes} > {L}

c:\windows\command /c cl /c /nologo @{L} /Fo{n} {1} | tail +1

puts the content of the cdebug, cflags, and cdefs macro into a temporary file, then runs the c compiler using the content of the temporary file as the arguments.  The output of the c compiler is piped to tail, so that the very first line of the output is eliminated.

Note:  Remember, an action command can contain multiple lines.

Note that DOS has a limitation of 306 characters on the command line.  To work around this limitation, many DOS application (like cl in the example above) can read additional arguments from a file.

To avoid typing c:\windows\command /c in all of your action commands, you may wish to define a macro on the ANY type like:

{SHELL} = c:\windows\command /c

Then you can write actions like:

{SHELL} echo {cdebug} {cflags} {cdefs} {cincludes} > {L}

Defining a macro in this fashion also allows you to easily change to a different command line interpreter.


Using Query Builder on Windows

Note:  For additional information, refer to your Release Notes (on your installation CD):  RELNOTES.TXT or RELNOTES.PDF.

Starting Query Builder

To start Query Builder for Windows using a remote connection to an Oracle Server:

On 32-bit Windows platforms (NT, 95, 98):

1	Your PC must be configured for network access.  This may require installation and configuration of additional hardware or software.  If you believe that your PC is not configured for network access, contact your system or network administrator.

SQL*Net must be installed.  See your SQL*Net documentation for more information.

2	Click Start [image] Programs [image] Oracle Forms Developer from the Taskbar.

3	Click Query Builder.


Running Query Builder under Windows

This topic describes aspects of Query Builder specific to its use under Microsoft Windows.

Executable

Query Builder for Windows includes the following executable, located in ORACLE_HOME\BIN :

OBE60.EXE


Using Schema Builder on Windows

Note:  For additional information, refer to your Release Notes (on your installation CD):  RELNOTES.TXT or RELNOTES.PDF.

Starting Schema Builder

To start Schema Builder for Windows using a remote connection to an Oracle Server:

On 32-bit Windows platforms (NT, 95, 98):

1	Your PC must be configured for network access.  This may require installation and configuration of additional hardware or software.  If you believe that your PC is not configured for network access, contact your system or network administrator.

SQL*Net must be installed.  See your SQL*Net documentation for more information.

2	Click Start [image] Programs [image] Oracle Forms Developer from the Taskbar.

3	Click Schema Builder.


Running Schema Builder under Windows

This topic describes aspects of Schema Builder specific to its use under Microsoft Windows.

Executable

Schema Builder for Windows includes the following executable, located in ORACLE_HOME\BIN :

OBS60.EXE


Using Procedure Builder on Windows

Note:  For additional information, refer to your Release Notes (on your installation CD):  RELNOTES.TXT or RELNOTES.PDF.

Starting Procedure Builder

To start Procedure Builder for Windows using a remote connection to an Oracle Server:

On 32-bit Windows platforms (NT, 95, 98):

1	Your PC must be configured for network access.  This may require installation and configuration of additional hardware or software.  If you believe that your PC is not configured for network access, contact your system or network administrator.

SQL*Net must be installed.  See your SQL*Net documentation for more information.

2	Click Start [image] Programs [image] Oracle Forms Developer from the Taskbar.

3	Click Procedure Builder.

To learn how to use Procedure Builder, click Help [image] Cue Cards, for step-by-step procedures on the most commonly performed tasks, or Help [image] Quick Tour for an overview of Procedure Builder itself.

If you are new to Procedure Builder, review the book Oracle Procedure Builder Getting Started.  This is a tutorial designed to give you a quick introduction to the basics of Procedure Builder. To access the book online, choose Help [image] Manuals and navigate to Getting Started under Online Manuals.

Database Connection Errors

If you receive an error in the ORA-3100 to ORA-3199 range when you try to log on to the Oracle server, there may not be enough real-mode memory to establish a connection with an ORACLE database.

NETINIT7.EXE solves this problem by reserving memory for server connections.  NETINIT7 uses the configuration parameter, WIN_REMOTE_SESSIONS, to determine how much real-mode memory to reserve for connections to the server.

Directories

The TOOLS directory contains several modules of general interest in the following subdirectories:

Name	Contents
\COMMON60	Message files, resource files, font aliasing files, color palettes, and other files common to all the components.
\DBTAB60	Database tables.
\DEVDEM60	All the files used in the demos.
\DOC60	Online help, cue card, and Quick Tour files.
\OPEN2K60	ODBC files and source control information.


Running Procedure Builder under Windows

This topic describes aspects of Procedure Builder that are specific to its use under Microsoft Windows.

Executable

Procedure Builder for Windows includes the following executable, located in ORACLE_HOME\BIN :

DE60.EXE


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 timesaving 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.