GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Oracle Forms 4.0

 Print  |  
Question:  how will you create a formula or a summary column and refer it other fields



September 09, 2008 20:33:10 #1
 renukuntanagaraj   Member Since: September 2008    Total Comments: 1 

RE: how will you create a formula or a summary column and refer it other fields
 

1. Open data model editor, increase the height of the group to make place for the formula column or summary column.
2. Select the formula column tool button in the tool palette and place it after the last field in the group.
3. Open the property palette of the formula column and change the name as you want, click on property PL/SQL formulae property and write the complete formula and compile it.
4. Close the program unit editor and now the formula column is created.

     

 

Back To Question