how can we write trigger in trigger????????
can we write one trigger on two table???
- 2 Answers
- 4867 Views
- Value Labs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sudipta santra
No we can not attach one common trigger for multiple tables
but it is possible in vise-varsa.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / abhisudipta
Yes , I am again, my previous answer is correct only for the
2nd question.
In case of the 1st question: I would like to say that if we
use execute immediate in a procedure or function , there
write the script of creating the new trigger and then that
procedure/function is being called from the trigger body
then only it works.
| Is This Answer Correct ? | 2 Yes | 0 No |
How to insert a record into a table?
How to change user password in oracle?
when loggined as SYSTEM,how to display all the users of database using sql query?
What is blob data type in oracle?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
How to bring a tablespace online?
Explain the features of oracle?
difference between procedures and function?
What is use of oracle?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
What happens to the current transaction if the session is ended?
What are the execution control statements?
Oracle General 
