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 the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

603


if some data is not transfered where it will get stored

1468


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

1608


Can we invoke one form from another in a multi-forms application?

645


did u received a single file or multiple files

1614






How can we generate report output in excel format?

563


why the Ctl file u put only in bin folder why not in other folder

1604


suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1602


What is a canvas in oracle forms?

600


Why oracle forms required?

573


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

1629


how report can be generated if we have the database designed in oracle 10g?

1468


what is tripstop report?

1362


How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1650


What are the various configuration files that are used by oracle forms?

579