Thanks Suman for information provided.I will post ...

2009-04-08T14:20:00.000-07:00

Thanks Suman for information provided.I will post these as articles.

12You can use the lexical parameters at From claus...

2009-04-06T10:56:00.000-07:00

12
You can use the lexical parameters at From clause but you have to use lexical parameter as given below.

SELECT 'last_name' client_last_name, 'first_name' client_first_name,
'mailing_address1' mailing_address, 'city' city
FROM dual
WHERE 1=2
&RGROUP1

In above query I have used 2 lexical parameters and while calling the above report pass the &RGOUP1 values using the below statement.

:RGROUP1 := 'UNION SELECT 'last_name' client_last_name, 'first_name'
client_first_name, 'mailing_address1' mailing_address, 'city' city
FROM emp_det'
Using the above method you can generate the dynamic query in the report.

Lexical references is used to runtime dynamic where conditions. If you create query through query builder colon(:) must be used and this is used in after parameter form.

You can use the lexical parameters at From clause but you have to use lexical parameter as given below.

SELECT 'last_name' client_last_name 'first_name' client_first_name
'mailing_address1' mailing_address 'city' city

FROM dual
WHERE 1 2
&RGROUP1

In above query I have used 2 lexical parameters and while calling the above report pass the &RGOUP1 values using the below statement.

:RGROUP1 : 'UNION
SELECT 'last_name' client_last_name 'first_name'
client_first_name 'mailing_address1' mailing_address 'city' city

FROM emp_det'
Using the above method you can generate the dynamic query in the report.

12
Scroll bar on tab pages
Can we add scroll bar at on all tab pages in a single canvas? If yes then how:

You can put a Stacked Canvas on Tab Pages. A Stack Canvas can have Scroll Bars. You Can hide and show the Stacked canvas according to requirements.

12
Open Form Example
Give an example for open_form with parameter passing from one form to another form

BEGIN
CALL_FORM('FORM2'
NO_HIDE
DO_REPLACE -- replace menu
NO_QUERY_ONLY
SHARE_LIBRARY_DATA);
END;

look at the forms help for the differences between OPEN_FORM and CALL_FORM.

1 What is purpose and order of firing the followin...

2009-04-06T10:55:00.000-07:00

1 What is purpose and order of firing the following triggers
- on fetch
- on select
First on-select then on-fetch trigger is fired .
On-select is used to open and execute database query. on-fetch can be used in conjunction with on-select to replace the processing that normally occur in execute query built in procedure
1)On select fires first.

On select fFires when Forms Developer would normally execute the open cursor parse and execute phases of a query to identify

Comments on ITNirvanas (Datwarehousing/Oracle/Informatica/Unix/D2K Plus interview questions): Trigger Firing sequence in D2K (Oracle Forms)

Thanks Suman for information provided.I will post ...

12You can use the lexical parameters at From claus...

1 What is purpose and order of firing the followin...