Interested to Buy Any Domain ? << Click Here >> for more details...
Why is a Where clause faster than a group filter or a format
trigger?
- 1 Answers
- 4937 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Is it possible to execute a dynamic sql from forms?
Where is the external query executed at the client or the server?
If two groups are not linked in the data model editor, What is the hierarchy between them?
How can you execute the user defined triggers in forms 3.0 ?
what is an object groups?
Can you change the alert messages at run-time?
What is an Alert ?
What is a property clause?
what are the new features introduced in oracle form services in 11g release 2?
What is the use of place holder column?
what is bit map and character mode
Hi...... I created a report which is geneated in .txt format. What I do for this is 1.First I change the system parameter mode to character in the report. 2.Then I place a button in my form to call the report. code in the button is as follows.. DECLARE rePid REPORT_OBJECT; rep_hndl VARCHAR2(100); BEGIN rePid := Find_Report_Object('reptxt.rdf'); Set_Report_Object_Property(rePid,Report_deStype,FILE); Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf'); Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt'); rep_hndl := Run_Report_Object(rePid); END; and it is working.. Now the problam is that when I preview the report from the report builder, it is in the format I needed. But when I run the form and run the report,Its alligment is not correct. Regards abc
Oracle General 
