GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Oracle Forms 3.0
Go To First  |  Previous Question  |  Next Question 
 Oracle Forms 3.0  |  Question 63 of 66    Print  
Hi,
what is place holder column?
where we can use other than formula column?

  
Total Answers and Comments: 4 Last Update: September 16, 2008     Asked by: babloo 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: Krishna
 

Place Holder column is created in reports

A placeholder is a column for which you set the datatype and value in PL/SQL that you define. Placeholder columns are useful when you want to selectively set the value of a column (e.g., each time the nth record is fetched, or each time a record containing a specific value is fetched, etc.). You can set the value of a placeholder column in the following places: the Before Report Trigger, if the placeholder is a report-level column a report-level formula column, if the placeholder is a report-level column a formula in the placeholder's group or a group below it (the value is set once for each record of the group)



Above answer was rated as good by the following members:
sumanpani
July 03, 2006 15:17:36   #1  
Krishna        

RE: Hi,what is place holder column?where w...

Place Holder column is created in reports

A placeholder is a column for which you set the datatype and value in PL/SQL that you define. Placeholder columns are useful when you want to selectively set the value of a column (e.g. each time the nth record is fetched or each time a record containing a specific value is fetched etc.). You can set the value of a placeholder column in the following places: the Before Report Trigger if the placeholder is a report-level column a report-level formula column if the placeholder is a report-level column a formula in the placeholder's group or a group below it (the value is set once for each record of the group)


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
October 04, 2006 06:29:22   #2  
DEEPAK KUMAR        

RE: Hi,what is place holder column?where w...
Place holder is a column that store the value in A VariAble
 
Is this answer useful? Yes | No
December 06, 2006 08:49:46   #3  
rampratap409 Member Since: September 2006   Contribution: 111    

RE: Hi,what is place holder column?where w...

Place holder column is the name of variable which can hold a calculated value like ( sum avg..) or the value can be set by function or by a pl/sql block.

use of place holder column for aggrigate function is not advised for that use summary column.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
September 16, 2008 02:25:35   #4  
sumanpani Member Since: September 2008   Contribution: 11    

RE: Hi,what is place holder column?where we can use other than formula column?

A placeholder is a column for which you set the datatype and value in PL/SQL that you define. You can set the value of a placeholder column in the following places:

n the Before Report Trigger if the placeholder is a report-level column

n a report-level formula column if the placeholder is a report-level column

To create or edit a placeholder column:


 
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