What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE
TRIGGERS ?
Answer / guest
These triggers are executes when inserting,deleting and
updating operations are performed and can be used to
change the default function of insert,delete or update
respectively.
For Eg, instead of inserting a row in a table an
existing row can be updated in the same table.
| Is This Answer Correct ? | 1 Yes | 0 No |
How can a break order be created on a column in an existing group?
What is the User-Named Editor?
What is the difference between system.current_field and system.cursor_field ?
what is sequence of execution of following triggers 1.when-validate-item 2.post-change 3.key-next-item 4.post-text-item
Is it possible to execute a dynamic sql from forms?
what ia an object groups?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
What are the different display styles of list items?
Name of the functions used to get/set canvas properties?
Identify package function from the following ?
What are the type of User Exits ?
When a form is invoked with call_form, Does oracle forms issues a save point?