What is the difference between ON-VALIDATE-FIELD trigger and
a POST-CHANGE trigger ?
Answer / guest
When you changes the Existing value to null, the
On-validate field trigger will fire post change trigger
will not fire. At the time of execute-query post-chage
trigger will fire, on-validate field trigger will not fire.
Is This Answer Correct ? | 7 Yes | 0 No |
What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
What are parameters?
When a form is invoked with call_form, Does oracle forms issues a save point?
what r the various types of reports
What are the type of triggers available in Oracle Reports ?
3 Answers Convergys, IBM, KPIT, Oracle, TCS,
When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
can i write commit in Before report trigger
System.effective_date system variable is read only True/False
What are the different types of Record Groups?
Do user parameters appear in the data modal editor in 2.5?
i want print character reports in 10g application reports pl help me my id is yoga.roh@gmail.com
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