Which of the above methods is the faster method?

Answer Posted / guest

1. Perform the calculation in the SQL statements itself.
2. Use a calculated / summary column in the data model.


answer ::
1. Perform the calculation in the SQL statements itself.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do u place it in required folder

1478


a text item is there what r the different types of triggers associated with it

1514


How can we generate report output in excel format?

555


I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2282


How can we expand Parameter Form Canvas on Reports 6i?

1959






what exactly u write in when_new_form_instance

2900


i am writing a query select EmpNo from Emp how can i call in after parameter form

1600


Explain how can you use the same lov for 2 columns?

643


Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

1697


List the different types of columns in oracle reports.

572


What is a user exit program in oracle reports?

578


what is a package n what r the packages availbla in report

1615


how do u compile a form i.e .fmb file in Unix or in dos

4024


In what sequence do triggers get fired by oracle forms?

539


Explain the different levels at which oracle form services interact.

609