D2K - If there are 1 to 10 records, how many times between pages trigger will fire?If there are 1 to 2 rec

GeekInterview.com > Interview Questions > Oracle > D2K

Go To First | Previous Question | Next Question

D2K | Question 20 of 71

If there are 1 to 10 records, how many times between pages trigger will fire?
If there are 1 to 2 records? and how many times it will fire from 10th to 1st record?

Total Answers and Comments: 9

Last Update: September 10, 2007 Asked by: babloo

Sponsored Links

Best Rated Answer

—

Submitted by: Mital Mehta

5 times

because there are 10 records in whole report . and record will come on 1 page so. there will be 5 pages in whole report . so 5 times it will fire

Above answer was rated as good by the following members:
bc_sumanamara

May 06, 2006 09:12:20

salim

RE: If there are 1 to 10 records, how many times betwe...

only once

Is this answer useful? Yes | No

May 25, 2006 07:27:19

Devesh Kumar

RE: If there are 1 to 10 records, how many times betwe...

Hi can u clarify the answer....Between the Records.

Because Between pages trigger fires on all pages except on the very first page...so how can it be only once..for the records

Thanks

Devesh

Is this answer useful? Yes | No

September 02, 2006 05:47:08

Uttam

RE: If there are 1 to 10 records, how many times betwe...

One time only

Is this answer useful? Yes | No

October 06, 2006 07:40:54

Sanjeeva Kumar

RE: If there are 1 to 10 records, how many times betwe...

Between pages trigger fires only when u navigate from one page of report to another page first time. No matters how many records u have. It depends on the no of pages u have in the reports and ur first time navigation between them.

Is this answer useful? Yes | No

November 24, 2006 04:29:20

Rakesh Bhardwaj

If there are 1 to 10 records, how many times betwe...

suppose there are n pages in report then between pages trigger will fire (n-1) times

Is this answer useful? Yes | No

March 15, 2007 15:31:48

geetha24

Member Since: March 2006 Contribution: 27

RE: If there are 1 to 10 records, how many times betwe...

Also between pages will fire only for the first time when you navigate to the pages. When you navigate to the pages 2nd time it will not fire.

- Geetha

Is this answer useful? Yes | No

June 21, 2007 04:26:08

Mital Mehta

RE: If there are 1 to 10 records, how many times betwe...

5 times

because there are 10 records in whole report . and record will come on 1 page so. there will be 5 pages in whole report . so 5 times it will fire

Is this answer useful? Yes | No

1 0