Where clause filter's the data at the time of data fetching or select

Why is a Where clause faster than a group filter or a format
trigger?

Question Posted / anil_abbireddy

1 Answers
4748 Views
I also Faced
E-Mail Answers

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 do you understand by lov and how can it be used?

1013

What is the difference between BPA AND Contract What are documents and test cases u followed

2327

List out the oracle forms configuration files?

1005

What do you understand by oracle forms?

975

what exactly u write in when_new_form_instance

3378

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

1069

What is the difference between bind and lexical parameter?

1010

can you convert or reverse engineer a fmx back to a fmb file?

1089

Explain how can you use the same lov for 2 columns?

1079

Explain the various types of oracle report?

1025

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

1832

In what sequence do triggers get fired by oracle forms?

913

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...