|Oracle Master Glossary||
call interface (1) A set of standard software routines used to access an ORACLE database. Also called the OCI for ORACLE Call Interface. (2) An interface that allows RUNREP and/or SQLREP to be linked with a user or other ORACLE program, such as SQL*Menu. See also interface.
call flow In a user-developed gateway, the order of execution of interface calls.
callback A function that is defined as an attribute of an entity. It is applied ("called back") by the toolkit when some event specific to that entity is delivered.
candidate row Any row that might satisfy a query, or a row fetched as an intermediate step of executing a query, that satisfies some of the query's criteria, but has not yet been tested against all the criteria.
canvas A workspace on which the SQL*Forms designer arranges items and boilerplate objects to be displayed for the operator. Each canvas has an associated view. See also painting region.
canvas-view The one-to-one relationship between a canvas and its view.
capabilities table In a user-developed gateway, a built-in table listing the default gateway server capabilities. See also delta capabilities table.
Cartesian product When you deactivate a relationship that is the only path relating two data sources, then execute a query using fields from both sides of the relationship, the result is a Cartesian product. The query combines all rows from all included data sources. A Cartesian product always retrieves many rows and information that is seldom useful. For example, if two data sources each contain 100 rows, the resulting Cartesian product will be ten thousand rows.
cascade delete An automatic process such that when one object is deleted, all the subordinate objects (and their subordinates and so on) are also deleted.
cascade update An automatic process such that when a primary key or a unique identifier of an object has its value changed, all related objects that explicitly quote the original value have their values changed to reflect this new value. Similarly, cascade update may also refer to derived data and controlled replication of any data.
CASE (Computer Aided Systems Engineering) The combination of graphical, dictionary, generator, project management, and other software tools that can be used to assist computer development staff engineers and maintain high quality systems for their end users, within the framework of a structured method.
CASE*Dictionary A multi-user repository for system development staff to record all significant results from the strategy, analysis, design, and implementation stages of the system development.
CASE*Designer (1) A workstation-based development environment designed for use by system engineers such as analysts and designers. It provides a multi-windowed, multi-user, networked access to many development tools, including CASE*Dictionary and SQL*Forms. It provides a set of interactive diagrammers and plotting facilities to enable concepts, such as entity relationship models, to be manipulated and output graphically. It is fully integrated with CASE*Dictionary . (2) The graphic interface through which the user interacts with the information in CASE*Dictionary .
CASE*Dictionary The database dictionary, which is a multi-user repository for system development staff to record all significant results from the strategy, analysis, design, and implementation stages of the system development. It includes a complete, forms-based interface as well as several utilities. Formerly known as SQL*Design Dictionary.
CASE*Dictionary Definition Tables Tables that hold information defining the types of elements and associations that may be recorded using CASE*Dictionary . A number of CASE*Dictionary instances may be controlled by a single set of CASE*Dictionary definition tables.
CASE*Dictionary Manager An ORACLE user who is a CASE*Dictionary User with the authority to grant access rights to other CASE*Dictionary users for an application system.
CASE*Dictionary Screen The electronic equivalent of a document or form displayed on your computer terminal. The screens are built using the SQL*Forms Utility from Oracle, and they permit the insertion, amendment, query, and deletion of information from the Dictionary database. To assist in the navigation of multi-page screens, the display provides an indication of the relative position now occupied; for example, Page 2 of 3, in the top right-hand corner of the screen.
CASE*Dictionary table owner The CASE*Dictionary product has an ORACLE database that it uses for the CASE repository of information about elements and diagrams. The CASE*Dictionary table owner is the ORACLE user who sets up these ORACLE tables, and who would grant access rights to other development staff to use the Dictionary. Typically, this owner would be a database administrator or system administrator.
CASE*Dictionary tables Tables used to hold element and association definitions recorded via a CASE*Dictionary instance. Each instance has a set of CASE*Dictionary tables.
CASE*Dictionary user Anyone who needs to access the Dictionary through any of the CASE tools. Users would typically include analysts, designers, builders and data administrators.
Oracle Case Exchange A software tool that enables information to be transferred from a third-party CASE tool to the Oracle CASE tools, or vice versa.
CASE*Generator A family of software products that use information held within CASE*Dictionary to generate application programs in various languages such as SQL*Forms, SQL*ReportWriter, and SQL*Plus.
CASE*Method A structured approach to engineering systems in a data processing environment. It consists of a set of stages, tasks, deliverables, and techniques, which lead you through all steps in the life-cycle of a system. It can be automated by combining CASE*Dictionary , CASE*Designer , and the CASE*Generator family of software products. Formerly known as SQL*Development Method.
catalog Another name for data dictionary.
category 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.
category axis See discrete axis.
CDATA The "character data" declared content character type. This type indicates that all SGML delimiters except the end tag delimiter (</) are ignored.
central administration A single Oracle Names administrative region for a SQL*Net network.
central tables See system-owned tables.
CEO Comprehensive Electronic Office, Data General's integrated office automation software, with which SQL*Forms is compatible using the ORACLE Interface for CEO.
CGM (Computer Graphics Metafile) A file format recognized internationally and used to store and transport object-oriented graphics from one system or program to another.
chained row A row that is stored in more than one database block, and therefore has more than one row piece. See also row piece.
change event See external event.
CHAR datatype 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.
char field In SQL*Forms, a field whose value is a sequence of characters.
character (1) A single location on a computer system capable of holding one alphabetic character or numeric digit. One or more characters are held in a field. One or more fields make up a record, and one or more records may be held in a file or database table. (2) The format of an attribute, which may contain alphabetic characters or numeric digits.
character mode An editing mode used when entering information on a screen; there are two character modes: insert and replace.
character string A group of sequential letters, numerals, or symbols, usually comprising a word or name, or portion thereof.
characteristic See attribute.
chart element A bar, line, symbol, or other graphical object that represents a single value for a field.
chart template A collection of attributes and properties that defines the format of a chart.
check box A interface element, appearing as a small square, that a user can toggle on or off.
check constraint A set of rules that govern whether a value can be updated or deleted.
checkpoint (CKPT) At specific times, all modified database buffers in the SGA are written to the data files by DBWR; this event is called a checkpoint. The checkpoint process is responsible for signalling DBWR at checkpoints and updating all the data files and control files of the database to indicate the most recent checkpoint. CKPT is optional; if not present, LGWR assumes the responsibilities of CKPT.
checksum An error-checking algorithm.
child 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.
child query See detail query.
choose To pick an item, using a mouse or key combination. See also click and select.
CICS (Customer Information Control System) IBM software that supports the IBM transaction processing system.
CICS Attach An optional Oracle product that allows CICS users to connect to and manipulate data on an ORACLE for MVS database.
circular reference A circular reference occurs when two (or more) defined fields depend on each other for definition. Oracle Data Browser cannot process the circular reference and will display an error message when you execute a query that contains one.
class A level of authority to issue specific types of VM commands. Class G is the "general user" class. A user with class G privileges can issue basic CP commands. In addition to class G, the ORACLE DBA machine must have class A (primary system operator), class B (system resource operator), and class E (system analyst) privileges.
classification A hierarchical level that denotes the sensitivity of the information that is labeled. Classifications are used as a means of restricting access to information.
clause A part of a SQL statement that does not constitute the full statement; for example, a "WHERE clause."
cleanup pass A pass made through the SGA buffers by background process PMON in order to clean up resources held by any process that terminated abnormally.
clearance The highest label for which users are authorized to read and/or write information. Users can only access objects at their clearance level and below.
CLI file The standard dialogue file that contains the information used by the autologon facility to invoke the remote server process. See also autologon facility and dialogue files.
CLI See Command Line Interpreter.
click To press and quickly release the left mouse button (or the right mouse button if your mouse is configured for a left-handed person). You generally use the click function to highlight items in a window. See also choose and double-click.
click and hold To press and hold down the left mouse button. You use the click and hold function primarily to make a choice within a choice. For example, you may click and hold on a menu option to bring up a submenu, and then release it after making a selection from the submenu. See also choose.
client 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. See also server process, two-task, and TNS client.
client profile The properties of a client, often shared by many clients. Includes the protocols used, preferred Interchanges, preferred Names severs, and the logging and tracing data for a client.
client type A group of clients who share the same community and who have the same preferred Connection Manager. All members of a client type can share a TNSNAV.ORA file. Similar to client profile.
client-server architecture Software architecture based on a 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. This architecture allows for separate processing between the database server and the client application programs. 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. See also client, distributed processing, and server process.
clipboard (1) An area that holds data that the user has cut or copied from a view. The clipboard is global to the system, thus allowing the user to pass data between different applications. (2) In SQL*Forms, the Layout Editor memory buffer. An object remains in the clipboard until you cut or copy another object, or until you quit SQL*Forms.
Clipboard In Oracle Graphics, a memory buffer. An object remains on the Clipboard until you cut or copy another object, or until you quit Oracle Graphics.
clipboard target The view designated to receive events automatically generated by the special Cut, Copy, Paste, and Clear menu items.
clipping rectangle The clipping rectangle is the area of a view in which drawing can take place.
close box A small rectangular area of a window that the user can click in to close the window. Close boxes are not available on all platforms.
closed database A database that is associated with an instance but is not open. A database must be mounted and closed for the DBA to perform certain database maintenance tasks. A database is mounted, opened, and closed using the SQL statement ALTER DATABASE.
cluster (1) A database structure in which one or more tables are stored together in the same block. A cluster allows tables that contain common information to be accessed concurrently. Tables that are clustered have one or more columns in common and are frequently referenced together in queries (especially joins). See also cluster index and cluster key. (2) In network communication, a configuration in which two or more terminals are connected to a single line or single modem.
cluster columns See cluster key.
cluster controller A specialized computer that operates between a group of terminals and the mainframe, gathering messages and clustering them for more efficient transmission to the mainframe.
cluster index An index manually created after a cluster of database tables has been created. The index must be created before any DML statements can operate on the clustered tables. The index is created on the cluster key with the SQL statement CREATE INDEX.
cluster key The related column of the tables in a cluster. The cluster key is indexed so that rows of the cluster can be retrieved with a minimum amount of I/O. Because the data in a cluster key of an index cluster (a non-hash cluster) is stored only once for multiple tables, clusters may store a set of tables more efficiently than if the tables were stored individually (not clustered).
CMDFILE A command line argument that allows you to specify a file that contains a set of arguments for SQLREP or RUNREP.
CMS (Conversational Monitor System) The component of the VM environment that provides the interface between the VM user and the facilities of CP (Control Program). CMS provides facilities for interactive program development and testing, document preparation, electronic mail, and many other facilities. ORACLE for VM runs in the CMS environment.
coaxial cable A type of network medium used in LANs. Consists of an inner conducting wire and an outer conductive metal layer separated by insulation.
collation sequence A sequence of characters in which every character is defined to be either greater than or less than every other character and that can be used to order the characters, as in alphabetization. A collation sequence depends on the operating system's character set. Most operating systems use either ASCII or EBCDIC. The collating sequence is also affected by the INIT.ORA parameter LANGUAGE; different languages have different characters, and therefore different collating sequences.
color palette Contains all the colors available to the windowing system, the drawing surface, or a window and its views.
column (1) A vertical space in a database table that represents a particular domain of data. A column has a column name and a specific datatype. For example, in a table of employee information, all of the employees' dates of hire would constitute one column. A record group column represents a database column. (2) In the context of CASE, a table is often the implementation of an entity. The columns of the table are used to implement the attributes of the entity and its relationships.
column constraint See integrity constraint.
column expression An expression in a SELECT statement that defines which database column(s) are retrieved. It may be a column name or a valid SQL expression referencing a column name.
column heading The top line of a column in the Results Window, containing the name of the column. Also called a print title. See also label.
column indexing mode The way in which the SQL*TextRetrieval indexing utilities specify or omit information relating to the column in which an indexed word occurs. There are three modes: standard, column-specific, and single-indexing.
column usage The usage of a column by a module. Also called Module Column Usage. See also Module Data Usage.
comma-delimited This term refers to the format of an ASCII file that contains a comma to separate each column value and a return key to separate each row. Oracle Data Browser can export data to the comma-delimited format with the Export Data... option from the File menu. See also ASCII and tab-delimited.
command An instruction to or request of a program, application, operating system, or other software, to perform a particular task. Commands may be single words or may require additional phrases, variously called arguments, options, parameters, and qualifiers. Unlike statements, commands execute as soon as you enter them.
command file A file containing a sequence of commands that you can otherwise enter interactively. The file is saved for convenience and re-execution. Command files are often called by operating-system specific names, such as COM files, DCL files, EXEC files, or BAT or CLI files.
command line A line on a computer display on which typed in commands appear. An example of a command line is the area next to the DOS prompt on a personal computer. See also prompt.
Command Line Interpreter (CLI) An AOS/VS operating system command language. CLI allows communication with the operating system. Typically, AOS/VS runs a CLI process for each user who logs on under EXEC.
command procedure See command file.
comment (1) A language construct for the inclusion of explanatory text in a program, the execution of which remains unaffected. (2) A multi-line field in which you can enter explanatory information about a SQL*ReportWriter object.
commit (1) To make permanent changes to data (inserts, updates, deletes) in the database. Before changes are committed, both the old and new data exist so that changes can be stored or the data can be restored to its prior state. (2) In SQL*Forms, to store new or changed records from the workspace into a table in the database.
common function A faithful copy of a function that appears elsewhere in the function hierarchy. To eliminate identical functions, one or more common functions may be created, each of which is a copy of a master function.
communications protocol A set of implemented standards or rules governing the transmission of data across a network. A communications protocol includes detailed specifications for data transmission. A protocol may require several layers of software and may connect homogeneous or heterogeneous computers.
community A group of network clients and servers that run TNS-based software and that can communicate using the same industry-standard protocol.
community cost A number assigned to a community to reflect its relative communications speed and throughput. The network administrator assigns costs in the file TNSNET.ORA. The cost is used by the Navigator when selecting the best path to a destination.
community name A unique name used to identify a TNS community in a TNS network.
comparison operator An operator used to indicate a comparison between two values, such as the equal sign in the Oracle Data Browser condition DEPTNO=10. Rows in which the comparison results in true are shown in the Results Window, while rows in which the comparison returns false are not retrieved.
compile To translate a source program as written by the application developer into a binary, executable format. In SQL*ReportWriter, PL/SQL program units must be compiled before they are executed.
composite key A key value for a database table that is formed by more than one column. Composite key columns are used in concatenated indexes. See also key and concatenated index.
composite relationship A relationship that relates two or more fields in one data source to two or more fields in another data source at the same time, as one relationship, not two (or more) separate relationships. See also relationship.
compound document A document that contains information in several formats; text, graphic, and image. Also called multimedia document.
compound string A text string containing several components, each of which may be of a different font, size, and/or direction.
computation Used to perform runtime calculations on data fetched from the database. These calculations are a superset of the kinds of calculations that can be done directly with a SELECT statement. See also formula column and summary column.
computed column See computation.
concatenated index (or key) An index that is created on more than one column of a table.
concatenation The joining of values, using the concatenation operator "||". For example, concatenation of the CHAR constants 'ABC' and 'XYZ' is denoted 'ABC' || 'XYZ', and the result is 'ABCXYZ'.
concept-based retrieval A textual search based on a concept rather than an exact word match. A concept automatically defines a list of search terms, phrases, and rules. Retrieval is accomplished at various levels of sophistication through various tools and methodologies (e.g. synonym lists, thesaurus, topic definitions, concept- based clustering). Also known as concept searching.
concurrency 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.
concurrent workstation A PC running both the ORACLE Server and Oracle tools or end-user tools simultaneously. See also dedicated PC.
condition (1) An operator that defines the parent's relationship to the child in a parent-child relationship. (2) An expression whose value is either true or false, such as X> 100. You add a condition to a query when you want the query to display only those rows that evaluate as true in your expression.
conditions box A box inside the Oracle Data Browser conditions panel where you enter a condition. See also condition and conditions panel.
conditions panel The portion of the Query Window that is used to add one or more conditions to a query. See also condition.
CONFIG.ORA The default ORACLE configuration file on a client PC that stores system defaults, such as options, for remote connections.
configuration In SQL*Net, the set of instructions for preparing network communications, as outlined in the SQL*Net documentation.
configuration files Files that are used to identify and characterize the components of a network. Configuration is largely a process of naming network components and identifying relationships among those components
confirmation box See alert.
connect To access an ORACLE or foreign database using a valid username and password. Similar to logging on to an operating system using an account name and password. You must connect if you want to create or modify queries or access a display stored in a database.
CONNECT DATA A portion of the connect descriptor, introduced by the keyword CONNECT DATA, that specifies the application to which the connection is to be made. The CONNECT DATA section of the connect descriptor includes the ORACLE System Identifier (SID).
connect descriptor A specially formatted description, usually identified by an alias, of the destination for a network connection. Connect descriptors are constructed using a set of keywords and values. They are mapped to service names to provide more convenient reference.
connect string The set of parameters, including a protocol, that SQL*Net uses to connect to a specific ORACLE instance on the network.
connection An interaction between two clients on a network. TNS connections are originated by an initiator (clinet) who requests a connection with a destination (server).
Connection Manager The component of the MultiProtocol Interchange that detects, establishes, and maintains data connections over a TNS network. The Connection Manager contains a listener and multiple data pumps.
connection request A notification sent by an initiator and received by a listener that indicates that the initiator wants to start a TNS connection.
consistency (data) A database requirement that all related data be updated together in the proper order, and that if there is redundant data that it agree. Consistency ensures that the data a user is viewing or changing is not changed (by other users) until the user is finished with the data.
consistency check In SQL*Forms, an operation to verify that data values meet some user-defined criteria.
constant A specific value that does not change, used in a calculation or condition for a query. For example, in the expression CREDIT_LIMIT *1.15, the number 1.15 is a constant value by which every value in the column CREDIT_LIMIT would be multiplied.
constant text In SQL*Forms, the fixed text that appears on a form; that is, everything except the field areas.
constraint 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. See also business constraint and check constraint.
construct A PL/SQL code structure. There are two types of constructs: non-value constructs do not return a value; value constructs return a value.
content canvas-view The primary canvas-view associated with a window.
content model (In SGML) A group contained in an element declaration that defines the allowable content for that element. The content model contains the model group and any exceptions to the model group.
content view A drawn view that supports a scrollable canvas. Every window has a single content view.
content view area The part of a window that contains the content view but not the scroll bar alleys or any platform-dependent decorations such as title bars, borders, close boxes, or size boxes.
context A concept that a designer uses to determine what parts of a form definition are currently accessible from within the SQL*Forms (Design) interface.
context area A temporary work area where ORACLE stores the current SQL statement and information necessary to process the statement. If the statement is a query, additional information is required, such as the result's column headings and one row of the result. See also cursor.
context handle In a user-developed gateway, a parameter used by all interface calls and service calls to identify the current context of the call, used to retain threading of calls. This parameter must never be modified by gateway developers.
continuous axis 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.
control A type of view that the user can modify to cause an action with visible results, such as changing the appearance of the control or changing settings that will modify a future action.
control block A block that does not correspond to any database table. In SQL*Forms, a block not associated with any database table or view. Control blocks can be used for performing automatic calculations, prompting users for information, or displaying hints. In CASE*Dictionary and CASE*Generator screens, the first block on the screen is referred to as the control block.
control file An administrative file that is required to start and run a database system. The control file records the physical structure of the database. For example, a control file contains the database name, names, and locations of a database's data files and redo log files, and the time stamp of database creation. The use of multiple identical control files is strongly recommended for protection of the file. During normal recovery procedures, the information in a database's control file is used to guide the automated progression of the recovery operation.
control file mini disks Installed as the DBA userid's 240 and 241 mini disks and contain information internal to ORACLE telling it how to find Database and Redo Log files. The names and locations of the Redo Log mini disks are defined in the ORAINIT parameter file.
control item An item that is not associated with any column in a table.
control key A key found on most keypads, used like the Shift key. When the Control key is held down in conjunction with another key, the latter key's "control" function is performed.
control points 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.
control-break A user-initiated keyboard command whereby the control and break keys are depressed together, causing the program to halt at the next available breakpoint. For example, a break report contains a control break.
controlled availability Selective control of the availability of data, at the database level, and sub-database level. For example, an administrator can disallow use of a specific application so that the application's data can be reloaded, without affecting other applications.
controller A unit that controls a local or remote cluster of terminals and PCs.
convert To convert a check box or radio group value that does not equate to either On or Off to one of those values, based on the value specified in the Other Values property for the target item.
CONVREP Executable command that converts a report definition from one storage format (e.g. database, .rdf file,.rep file, .rex file) to another.
coordinate plane The two-dimensional grid on which drawing takes place.
coordinate system The type of x, y units used to place and size objects in the Layout Editor. 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.
coordinates (X, Y) The location points for objects appearing in a painter or a layout. x and y coordinates determine the horizontal (x) and vertical (y) placement of layout objects.
copy To store a replica of a selected object on the Clipboard, so that it may be pasted elsewhere in an editor if desired.
copy context Master block information from one page that can be used as "context" for an associated detail block on a subsequent page.
copy function An alternative word for a common or slave function. See also common function.
correlated query A subquery that is executed repeatedly, once for each value of a candidate row selected by the main query. The outcome of each execution of the subquery depends on the values of one or more fields in the candidate row; that is, the results of the subquery depend on the results of the main query.
cost See community cost.
count (1) One of the summary operations available using the Summarize... option from the Fields menu. The count operation counts the number of records in your query, or in a specified part of your query, and displays it in the Results Window. (2) In SQL*Forms, the number of rows selected by the current query. Count is displayed on the SQL*Forms status line. See also Count Rows.
Count Rows A command on the Query menu that, when invoked, causes Oracle Data Browser to count the number of records that the query will retrieve and display the count, before query execution. See also count.
covert channels The paths that could be used by a higher level user to communicate information to a lower level user in violation of MAC policy.
CP (Control Program) The component of the VM environment that provides the interface between the computer hardware and the virtual machine. CP manages system resources, including the processor, DASD, and input/output devices.
CPU Support Identification A number used to identify a CPU at a customer site that has installed Oracle products. The number is assigned by Oracle Corporation.
CRC (Cyclic Redundancy Check) In networking, a check value appended to a message so that errors in transmission can be detected.
create To bring an object (a table, block, field, etc.) into existence, usually by defining its primary characteristics. See also define.
creating a database The process of making a database ready for initial use. Includes preparing the database files and loading initial database tables required by ORACLE Server. Database creation is accomplished using the SQL statement CREATE DATABASE.
creation label The label on the row which contains the object's definition. When you create an object, its definition is stored as a row in a data dictionary table. This row is automatically labeled at your DBMS label and indicates the label at which a object is created.
Critical Success Factor Any business event, dependency, deliverable or other factor which, if not attained, would seriously impair the likelihood of achieving a business objective.
cross memory services An MVS facility that allows data and program execution to cross address space boundaries in a secure and controlled manner.
cross product A group that owns two or more other groups and correlates values between them.
cross tab See matrix cell.
cross-application A term used to describe facilities in CASE*Dictionary that control the sharing of elements between application systems. Many of the elements in the dictionary are shared across several application systems. There are, therefore, several facilities within the CASE tools which act across more than one application system to control their use.
CRT definition The information describing one particular hardware terminal, including the function keys used for various Oracle products and escape sequences to enable various full-screen display characteristics, such as bold or reverse video. Definitions can be copied or altered using the CRT utility.
CRT file A file containing information about a terminal, its keys, the key mappings, and general escape sequences to enable different settings on the terminal. The filename usually indicates the particular hardware model. Various Oracle products require access to a CRT file to support full-screen displays.
CRT utility An ORACLE Server utility used to define or alter how terminals interact with Oracle software. This utility helps users create and edit CRT definitions, which are found in CRT files.
CRTCNV A conversion program used to convert CRT tables to load module format.
CSMA/CD (Carrier sense multiple access/collision detection) A method in which multiple workstations access a transmission medium (multiple access) by listening until no signals are detected (carrier sense), then transmitting and checking if more than one signal is present (collision detection). See also Ethernet.
CTCA (Channel-to-Channel Adaptor) A device that connects two CPUs through their channels.
current block In SQL*Forms, the block where the terminal's display cursor currently appears. Only one block can be the current block.
current field In SQL*Forms, the field in the current block or page in which data may currently be entered or edited. Only one field can be the current field.
current line In an editor such as the SQL*Plus editor, the line in the current buffer that editing commands will currently affect.
cursor (1) A screen marker, such as a blinking square or line, that indicates the current position of a user-controlled pointing device, usually a mouse. (2) A handle for a context area that allows you to access and manipulate data in the context area. (3) A handle (a name or pointer) for the memory associated with a specific statement. Although most ORACLE users rely on the automatic cursor handling of the ORACLE utilities, the programmatic interfaces offer application designers more control over cursors. For example, in precompiler application development, a cursor is a named resource available to a program and can be specifically used for the parsing of SQL statements embedded within the application. The application developer can code an application so that it controls the phases of SQL statement execution and thus improve application performance.
cursor coordinates The present location of a display cursor on a CRT, or a location on the screen designated by an X and Y coordinate pair.
cursor descriptor An area in memory reserved for a specific cursor (context area), containing certain cursor information.
cursor ID The name given to a cursor when the cursor is declared.
custom form A form that a user creates using SQL*Forms (Design). Contrast with default form.
cut To delete one or more SQL*ReportWriter, CASE*Designer, or Oracle Graphics objects and store them in the paste buffer, so that they may be pasted elsewhere in a painter, for example, if desired.
Copyright © 1996 Oracle Corporation.
All Rights Reserved.