Oracle Forms Interview Questions

Following Step need to setup before executing the Conversion Script Step 1: Logon to the Database server and connect to the database. Step 2: Run the below query and it should return five records: ...

I suggest you make use of triggers to take control over the default message.

You can try triggers such as ON-CLEAR-DETAILS trigger.

Oracle Applications - Folder Functionality are made use of in custom forms. Folder Functionality enables user to perform host of actions on fields such as ordering, renaming, resizing, moving, including, excluding etc., in a multi-row block.

First: check through Get_List_Element built_ins method that the both list has been selected with the value or not? if none is selected then all values should be populated . Second: Declare a varray a...

Create this procedure first:PROCEDURE Pop_List IS /* ** Built-in: CREATE_GROUP_FROM_QUERY **Example: Create a record group from a query, and populate it. */ list_id ITEM; list_name VARCHAR2(40) := &...

It is of type Character as you always compare

if :system.last_record = 'TRUE' then
........
........
end if;

the value of :system.last_record is either true or false.so it must be Boolean

Triggers are a special PL/SQL construct similar to procedures. However, a procedure is executed explicitly from another block via a procedure call, while a trigger is executed implicitly whenever the triggering event happens. The triggering event is either a INSERT, DELETE, or UPDATE command.

A forms trigger is a block of PL/SQL code that adds functionality to your application. Triggers are attached to objects in your application. When a trigger is fired, it executes the code it contai...

no

a single canvas have multiple windows :: NO

a single windows have multiple canvas :: yes

Valid values are: A, B & DIn forms, to give initial value as sysdate, we should user $$DBDATE$$ which gives the current time of server, which stores date of DD-MON-YYYY format. If you want to stor...

Erase removes an indicated global variable and releases the memory associated with it.

Property pallete is used to apply changes to only that object item, as visual attributes are used in more generic manner. Visual attributes are used  in the projects in which common specific...

Visual Attribute is the property in Property Pallete of object which deals with only text font,colour.

PRE-QUERY fire once when block goes in execute-query Mode.
and
POST-QUERY  fire=TOTAL NUMBER OF RECORDS RETRIEVED.
in the above case POST-QUERY fires 10 times.

POST will temporary save data in the relevant table.
If you do not use commit after post then the temporary saved data will be lost.
COMMIT permanently Save Data in the table

Create parameter list.
Add required parameters  with add_parameter(receiving_parameter_name, field type, sending_parameter_name)
Now pass this into call_form or open_form built_in procedure.

Text_IO Package in Oracle reports 10g Procedure/Exception/Function       DescriptionTEXT_IO.FCLOSE procedure that closes an open file.TEXT_IO.FILE_TYPE type that specifies a h...

genarate in hrmt and then open html file in excel .

System Variable in forms 10gSYSTEM.BLOCK_STATUS SYSTEM.COORDINATION_OPERATION SYSTEM.CURRENT_BLOCK SYSTEM.CURRENT_DATETIME SYSTEM.CURRENT_FORM SYSTEM.CURRENT_ITEM SYSTEM.CURRENT_VALUE SYSTEM.CURSOR_BL...

Record group triggersGET_GROUP_SELECTION Built-inGET_GROUP_SELECTION_COUNT Built-inGET_GROUP_ROW_COUNT Built-inGET_GROUP_RECORD_NUMBER Built-inSET_GROUP_CHAR_CELL Built-inSET_GROUP_number_CELL Built-i...

Populate_group_from_tree is also there in Forms10g.