Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

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

2041


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

1888


difference between global n context sensitive segments?

2671


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

2425


How can we generate report output in excel format?

997


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

1979


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

2988


what exactly u write in when_new_form_instance

3444


what is difference between group above and group left report

3820


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

1000


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

1086


from where do u receive the information to develop report

2010


What is the difference between flex mode and confined mode?

1049


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

2287


Explain the various types of oracle report?

1074