When is PRE-QUERY trigger executed ?
Answers were Sorted based on User's Feedback
Answer / guest
When Execute-query or count-query Package procedures are invoked
| Is This Answer Correct ? | 5 Yes | 1 No |
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 |
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 |
Error_Code is a package proecdure ?
What are the two types views available in the object navigator?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
What package procedure is used for calling another form ?
List out the oracle forms configuration files?
How is link tool operation different between reports 2 & 2.5?
What are the three types of user exits available ?
Explain about horizontal, Vertical tool bar canvas views?
how can u store a picture file in oracle database? explain the path/command?
What is a visual attribute?
What is the use of hidden column?
Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through