When is PRE-QUERY trigger executed ?

Answers were Sorted based on User's Feedback



When is PRE-QUERY trigger executed ?..

Answer / guest

When Execute-query or count-query Package procedures are invoked

Is This Answer Correct ?    5 Yes 1 No

When is PRE-QUERY trigger executed ?..

Answer / dinesh mohan upadhyay

pre query is executed fefore user goes to input.
it execute only one time for any block

Is This Answer Correct ?    2 Yes 0 No

When is PRE-QUERY trigger executed ?..

Answer / ravi

This trigger executes before the input goes into to any data
or control block. This trigger will execute only once when
data block gets input focus.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Forms Reports Interview Questions

What are the triggers associated with a check box?

2 Answers  


How to solve the error ?Frequency below its group? while running the report. Why it is happened and How to solve that?

2 Answers   Convergys,


Can we create two blocks with the same name in form 3.0 ?

1 Answers  


what are different types of canvas views?

3 Answers  


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

0 Answers  






With which function of summary item is the compute at options required?

1 Answers  


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

1 Answers  


What is a predefined exception available in forms 4.0?

2 Answers  


What is a Text_io Package?

4 Answers  


how to create parameterised form in oracle 10g? and create another form from the value of the form? AND how to assign value to a parameter? sincerly your mamun

2 Answers  


If two groups are not linked in the data model editor, What is the hierarchy between them?

1 Answers  


What do we mean by record group in oracle forms?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)