A table t is there.If you perform insert
,update and delete then the trigger will fire.What is
the minimum no of trigger required for a table.
Answers were Sorted based on User's Feedback
Answer / suresh babu
You can finish those all actions by using only one Trigger
Is This Answer Correct ? | 14 Yes | 4 No |
Answer / basanti jena
You can get it by using 1 trigger but maximum 12 trigger
Is This Answer Correct ? | 4 Yes | 0 No |
How to get the Installed Oracle Version Information ?
How to list all indexes in your schema?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
Find all employees in Dept “Marketing”.
What are data pump export and import modes?
What is system tablespace?
What is Hash Cluster ?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
how to find count rows in table without count function?
What is a read only transaction in oracle?
When a form is invoked with call_form, Does oracle forms issues a save point ?
what is RAID technology?which is better RAID 0+1 OR RAID 5?