List Of Questions On Forms Reports For Interview
Q – 1 How to call a URL from a menu using Oracle Forms 6i?
Ans- With use of the built_in named
Web.Show_Document(‘https:www.google.com’,_blank);
This like you can do.
Q – 2 How to restrict a parameter list with parameters?
Ans- The Restrict List to Predetermined Values is a checkbox that indicates whether a value for the parameter must be in the list of values.
For example, if you check Restrict List to Predetermined Values and the Initial Value does not match a value in the list of values, an error will be generated when you accept the Parameter property sheet. Similarly, if you set a value for the parameter on the command line or in a command script and it does not match a value in the list of values, an error will be generated when the report is run.
If you check Restrict List to Predetermined Values, a list of values will appear in the runtime parameter form. If you do not check it, a combo box will appear (i.e., you can enter values as well as select from the list).
Q – 3 What is the exact navigation to create a radio button in form6i? can we create the radio button in report6i?
Ans- Just create a radio button on the GUI part means layout editor(i.e on canvas) then n then the form will prompt you to create radiogroup under which this radio button will reside.
U just give name the radio group then give name the radio button. After that U have to go object navigator and select the property of the radiogroup then set the default value , oter value thats all. In report we can’t create radio button
Q – 4 How to hide the report in Apps?
Ans- We cannot hide the program in concurrent program window at the most u can diable it and u can hide the report in the SRS by “uncheck use in SRS chkbox”
Q – 5 When to use Place holder columns in Oracle Reports and what is a place holder column?
Ans- place holder columns are like global variables in the reports.
Variables declared in the PL/SQL code they cannot be the source of the field. So, if we assign the variables to placeholder columns they can be the source of the field since they are global variables.
Q – 6 How many types of trigger can be used in a table at a time?
Ans- We can define a trigger
1. For Each Row
2. For Each Statement
You can have the following triggers defined for the above two types:
1. BEFORE INSERT
2. BEFORE UPDATE
3. BEFORE DELETE
4. AFTER INSERT
5. AFTER UPDATE
6. AFTER DELETE
So it makes a total of 12.
Q – 7 How to call a report from Forms?
Ans- DECLARE
pl_id PARAMLIST;
BEGIN
pl_id := CREATE_PARAMETER_LIST(‘quotation’);
IF NOT ID_NULL(pl_id) THEN
Add_parameter(pl_id,’DESTYPE’,TEXT_PARAMETER, :DESTYPE);
ADD_PARAMETER(pl_id,’DESFORMAT’,TEXT_PARAMETER,:DESFORMAT);
ADD_PARAMETER(pl_id,’DESNAME’,TEXT_PARAMETER,:DESNAME);
Add_parameter(pl_id,’MODE’,TEXT_PARAMETER, ‘BITMAP’);
Add_parameter
(pl_id,’untcd’,TEXT_PARAMETER,:GLOBAL.G_STRUNITCODE);
Add_parameter
(pl_id,’FYCD’,TEXT_PARAMETER,:GLOBAL.G_STRFINYEARCODE);
Add_Parameter(pl_id, ‘PARAMFORM’, TEXT_PARAMETER, ‘NO’);
IF :id is not nullTHEN
Run_Product
(REPORTS,PLANDETAIL.rep’,SYNCHRONOUS,RUNTIME,FILESYSTEM,
pl_id, NULL);
DESTROY_PARAMETER_LIST(pl_id);
END IF;
end if;
end;
Q – 8 Suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?
Ans- T1’s Post-text-item trigger
:textT2 := :textT1;
Q – 9 What is the use of between page trigers in REPORTS?
Ans- In a Report of more than 1 page information. Then BETWEEN PAGES trigger fire when one move from one page to other page. In this trigger we can write process which is required to affect other page values.
Q – 10 How to create the triggers in the forms?
Ans- There are three types of triggers:
Form level
Block level
Item level
If you want to validate the values of an Item, usually use
Item level trigger, such as POST-CHANGE trigger.
Q – 11 Explain the Restricted and unrestricted procedure in Forms And reports and example as well?
Ans- Restricted procedure that affects the basic functions of SQL * Forms and Report . It cannot used in all triggers except key triggers.
Unrestricted procedure that does not interfere with the basic functions of SQL * Forms and Reports it can be used in any triggers.