What is a timer? - Timer is an â€Å"internal
time clock†that you can programmatically create to perform an
action each time the times.
What are the two phases of
block coordination? - There are two phases of block coordination:
the clear phase and the population phase. During, the clear phase,
Oracle Forms navigates internally to the detail block and flushes the
obsolete detail records. During the population phase, Oracle Forms
issues a SELECT statement to repopulate the detail block with detail
records associated with the new master record. These operations are
accomplished through the execution of triggers.
What are
Most Common types of Complex master-detail relationships? - There
are three most common types of complex master-detail relationships:
master with dependent details master with independent details detail
with two masters
What is a text list? - The text
list style list item appears as a rectangular box which displays the
fixed number of values. When the text list contains values that can not
be displayed, a vertical scroll bar appears, allowing the operator to
view and select values that are not displayed.
What is term? - The term is
terminal definition file that describes the terminal form which you are
using r20run.
What is use of term? - The term file
which key is correspond to which oracle report functions.
What
is pop list? - The pop list style list item appears initially as a
single field (similar to a text item field). When the operator selects
the list icon, a list of available choices appears.
What
is the maximum no of chars the parameter can store? - The maximum
no of chars the parameter can store is only valid for char parameters,
which can be up to 64K. No parameters default to 23 Bytes and Date
parameter default to 7 Bytes.
What are the default
extensions of the files created by library module? - The default
file extensions indicate the library module type and storage format .pll
- pl/sql library module binary
What are the
Coordination Properties in a Master-Detail relationship? - The
coordination properties are Deferred Auto-Query These Properties
determine when the population phase of block coordination should occur.
How
do you display console on a window? - The console includes the
status line and message line, and is displayed at the bottom of the
window to which it is assigned. To specify that the console should be
displayed, set the console window form property to the name of any
window in the form. To include the console, set console window to Null.
What
are the different Parameter types? - Text ParametersData Parameters
State any three mouse events system variables? -
System.mouse_button_pressedSystem.mouse_button_shift
What
are the types of calculated columns available? - Summary, Formula,
Placeholder column.
Explain about stacked canvas views?
- Stacked canvas view is displayed in a window on top of, or
â€Å"stacked†on the content canvas view assigned to that same
window. Stacked canvas views obscure some part of the underlying content
canvas view, and or often shown and hidden programmatically.
What
are the built_ins used the display the LOV? - Show_lov List_values
What
is the difference between SHOW_EDITOR and EDIT_TEXTITEM? - Show
editor is the generic built-in which accepts any editor name and takes
some input string and returns modified output string. Whereas the
edit_textitem built-in needs the input focus to be in the text item
before the built-in is executed.
What are the built-ins
that are used to Attach an LOV programmatically to an item? -
set_item_property get_item_property (by setting the LOV_NAME property)