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 the difference between flex mode and confined mode?
how to send file attachment from oracle forms
can you convert or reverse engineer a fmx back to a fmb file?
what are the new features introduced in oracle form services in 11g release 2?
Explain the different levels at which oracle form services interact.
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
Explain master-detail relationship with some examples.
what is tripstop report?
all steps of bitmap report?
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
What is an oracle report?
Name the different triggers supported by oracle reports and their firing order.
Explain the various types of oracle report?
Can we invoke one form from another in a multi-forms application?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g