Answer Detail: RE: Pre Query & Post Query

GeekInterview.com > Interview Questions > Oracle > D2K

Print |

Question: Pre Query & Post Query

Answer: How many times pre query and post query fired when we fetch 10 record from a table ?

February 02, 2009 05:17:29	#4
rahulkumar.it	Member Since: June 2008 Total Comments: 2
RE: Pre Query & Post Query
Pre Query fires only one time before the execution of the query , on the other hand Post Query fires after execution of the query, and one time for every rows returned. Thus if there are 5 returns rows in a query then Pre Query will fire for 1 time only but Post Query will fire for 5 times.