A query fetched 10 records How many times does a PRE-QUERY
Trigger and POST-QUERY Trigger will get executed ?
Answers were Sorted based on User's Feedback
Answer / guest
PRE-QUERY fires once.
POST-QUERY fires 10 times.
| Is This Answer Correct ? | 17 Yes | 0 No |
What are the different modals of windows?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the smae block level ?
What is synchronize?
Explain types of Block in forms4.0?
What is a user exit program in oracle reports?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.
difference between repeating frame and frame
Oracle me hindi notes chahiye or any web site address plz Give me in my email add,/////////// sunny.145@rediff.Com
What is a library in Forms 4.0?
Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;
What are the ways to monitor the performance of the report?