Why is a Where clause faster than a group filter or a format
trigger?
Answer Posted / anil_abbireddy
Where clause filter's the data at the time of data fetching
or selecting from the database where as grop or format
trigger will work on the result set of fetched data
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is responsibility and how u attach How to create user and how u attach with responsibility.
how report can be generated if we have the database designed in oracle 10g?
difference between global n context sensitive segments?
How can we expand Parameter Form Canvas on Reports 6i?
How can we generate report output in excel format?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
what exactly u write in when_new_form_instance
what is difference between group above and group left report
Name the different triggers associated with oracle forms having a master-detail relationship.
Name the different triggers supported by oracle reports and their firing order.
from where do u receive the information to develop report
What is the difference between flex mode and confined mode?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
Explain the various types of oracle report?