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

what is the difference between call_form, new_form and open_form?

705


Name the different triggers supported by oracle reports and their firing order.

579


Explain the different levels at which oracle form services interact.

593


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

4009


if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1468






If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

1807


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

636


In what situation u create the BPA.

1767


What is responsibility and how u attach How to create user and how u attach with responsibility.

1611


What is an oracle report?

596


difference between global n context sensitive segments?

2193


What is an oracle report? List its various types.

558


How can we generate report output in excel format?

546


what are the oracle forms services components include?

545


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

620