Which of the above methods is the faster method?
Answer / guest
1. Perform the calculation in the SQL statements itself.
2. Use a calculated / summary column in the data model.
answer ::
1. Perform the calculation in the SQL statements itself.
| Is This Answer Correct ? | 2 Yes | 0 No |
What do you mean by a pop-up window ?
What are parameters?
What is a canvas in oracle forms?
Can you change the alert messages at run-time?
What is the use of transactional triggers?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
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
What is a Trigger ?
how to eliminate duplictes in column except group and section?
What are the built-ins used for Creating and deleting groups?
what is place holder column
Can u explain me the Restricted and unrestricted procedure in Forms And reports and example as well ??