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

Name the different triggers associated with oracle forms having a master-detail relationship.

693


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

2152


if some data is not transfered where it will get stored

1665


Why oracle forms required?

766


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

2049


hiding item in report how like that properly,thats manually but at runtime i want to do

2845


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

1692


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1000


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.

1888


Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2050


What is a canvas in oracle forms?

786


from where do u receive the information to develop report

1725


What is the difference between flex mode and confined mode?

717


What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4299


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

1794