how can we write trigger in trigger????????
can we write one trigger on two table???
- 2 Answers
- 4846 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 would you best determine why your MVIEW couldnt FAST REFRESH?
11. Display the client number and name and the client number and name of the person who referred that client.
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Can a formula column be obtained through a select statement ?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
How to run create database statement?
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
How to connect ms access to oracle servers?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to pass a cursor variable to a procedure?
What is set verify off in oracle?
Oracle General 
