Interested to Buy Any Domain ? << Click Here >> for more details...
How to call a trigger inside a stored procedure?Give an
example.
- 2 Answers
- 8953 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manikandan. s
triggers can't be called from procedures or functions
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / jay
Inside procedure, insert/update/delete the row in table.
The table will automatically fire the trigger. Trigger will
get fire automatically.
| Is This Answer Correct ? | 8 Yes | 2 No |
What is columnar storage what is the advantage?
How to check database size in Oracle?
When system tablespace is created?
How can we Update a table with out using UPDATE command?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
What is a proxy object?
What is Trigger in Oracle?
What is the difference between I and G in Oracle?
Explain cascading triggers.
DBMS vs. RDBMS
How to find the duplicate rows count from employees table in oracle?
Oracle General 
