What
are the different default triggers created when Master Deletes Property is set
to Non-isolated?
Master
Deletes Property Resulting Triggers: Non-Isolated (the default)
On-Check-Delete-Master On-Clear-Details On-Populate-Details
What
are the different default triggers created when Master Deletes Property is set
to isolated?
Master Deletes Property Resulting Triggers:
Isolated On-Clear-Details On-Populate-Details
What
are the different default triggers created when Master Deletes Property is set
to Cascade?
Master Deletes Property Resulting Triggers:
Cascading On-Clear-Details On-Populate-Details Pre-delete
What
is the diff. bet. setting up of parameters in reports 2.0 reports2.5?
LOVs can be attached to parameters in the
reports 2.5 parameter form.
What
are the difference between lov & list item?
Lov is a
property where as list item is an item. A list item can have only one column,
lov can have one or more columns.
What
is the advantage of the library?
Libraries provide a convenient means of storing
client-side program units and sharing them among multiple applications. Once
you create a library, you can attach it to any other form, menu, or library
modules. When you can call library program units from triggers menu items
commands and user named routine, you write in the modules to which you have
attach the library. When a library attaches another library, program units in
the first library can reference program units in the attached library. Library
support dynamic loading-that is library program units are loaded into an
application only when needed. This can significantly reduce the run-time memory
requirements of applications.
What
is lexical reference? How can it be
created? –
Lexical
reference is place_holder for text that can be embedded in a SQL statements. A
lexical reference can be created using & before the column or parameter
name.
What
is system.coordination_operation?
It represents the coordination causing event
that occur on the master block in master-detail relation.
What
is synchronize?
It is a terminal screen with the internal
state of the form. It updates the screen display to reflect the information
that oracle forms has in its internal representation of the screen.
What
use of command line parameter cmd file?
It is a command line argument that allows you
to specify a file that contain a set of arguments for r20run.
What
is a Text_io Package?
It allows you to read and write information to
a file in the file system.
What
is forms_DDL?
Issues dynamic Sql statements at run time,
including server side pl/SQl and DDL
How
is link tool operation different bet. reports 2 & 2.5?
In Reports 2.0 the link tool has to be
selected and then two fields to be linked are selected and the link is
automatically created. In 2.5 the first field is selected and the link tool is
then used to link the first field to the second field.
What
are the different styles of activation of ole Objects?
In place activation, External activation
How
do you reference a Parameter?
In Pl/SQL, You can reference and set the
values of form parameters using bind variables syntax. Ex. PARAMETER name =
‘’ or :block.item = PARAMETER Parameter name
What
is the difference between object embedding & linking in Oracle forms?
In Oracle forms, Embedded objects become part
of the form module, and linked objects are references from a form module to a
linked source file.
Name
of the functions used to get/set canvas properties?
Get_view_property, Set_view_property
What
are the built-ins that are used for setting the LOV properties at runtime? get_lov_property
set_lov_property
What
are the built-ins used for processing rows?
Get_group_row_count(function)
Get_group_selection_count(function) Get_group_selection(function) Reset_group_selection(procedure)
Set_group_selection(procedure) Unset_group_selection(procedure)
What
are built-ins used for Processing rows?
GET_GROUP_ROW_COUNT(function)
GET_GROUP_SELECTION_COUNT(function) GET_GROUP_SELECTION(function)
RESET_GROUP_SELECTION(procedure) SET_GROUP_SELECTION(procedure)
UNSET_GROUP_SELECTION(procedure)
What
are the built-in used for getting cell values?
Get_group_char_cell(function)
Get_groupcell(function) Get_group_number_cell(function)
What
are the built-ins used for Getting cell values?
GET_GROUP_CHAR_CELL (function)
GET_GROUPCELL(function) GET_GROUP_NUMBET_CELL(function)
A
tleast how many set of data must a data model have before a data model can be
base on it?
Four
To
execute row from being displayed that still use column in the row which
property can be used?
Format trigger.
No comments :
Post a Comment