Which of the above methods is the faster method?
Answer / 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 |
How many windows in a form can have console?
How can we call a URL from a menu (Oracle Forms 6i)?
Explain the different levels at which oracle form services interact.
how to eliminate duplictes in column except group and section?
What is the difference between restricted and unrestricted package procedure ?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
What are the different defaust triggers created when Master Deletes Property is set to Non-isolated?
all steps of bitmap report?
I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent
How do you call other Oracle Products from Oracle Forms?
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
in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in that if any ething is selected then that will display in the report.supp if i am not selected any value then it should display all the values.how it is possible?can any one help me........