GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  D2K
Go To First  |  Previous Question  |  Next Question 
 D2K  |  Question 43 of 71    Print  
when execute query fire for a detail block and how many times pre query fire and how many times post query fire for a detail block?

  
Total Answers and Comments: 3 Last Update: April 01, 2009     Asked by: parveen sharma 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: gopal
 
1 time pre query and no of row times post query

Above answer was rated as good by the following members:
viveksis, Nitin2009
December 20, 2006 23:47:39   #1  
gopal        

RE: when execute query fire for a detail block and how...
1 time pre query and no of row times post query
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
June 17, 2008 04:55:30   #2  
shamkohli Member Since: June 2008   Contribution: 6    

RE: when execute query fire for a detail block and how many times pre query fire and how many times post query fire for a detail block?
Both Pre Query and Post Query would fire as many times as the number of records in the detail block
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 2Overall Rating: -1    
April 01, 2009 07:57:14   #3  
samareshp Member Since: April 2009   Contribution: 24    

RE: when execute query fire for a detail block and how many times pre query fire and how many times post query fire for a detail block?
pre query will fire ONCE
post query will fire as many records are there.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape