how many triggers we can create on a table
- 11 Answers
- 48554 Views
- G2 Technology, TCS, I also Faced
- E-Mail Answers
Answer Posted / samir
You can have 1 each INSTEAD OF trigger for INSERT, UPDATE,
and DELETE.
You can have as many AFTER triggers as you want up to the
limit of the total maximum number of SQL Server objects.
Within AFTER triggers, you can have only 1 FIRST and 1 LAST
trigger for INSERT, UPDATE, and DELETE.
This information is available in Books Online
under "Triggers".
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What is the data pump export utility?
How to install oracle odbc drivers?
What is dynamic proxy?
What operating systems are supported by oracle database 10g xe?
What is an oracle and why it is used?
How to call a stored function in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to convert dates to characters in oracle?
How do I learn what codesets are available in oracle?
How do I start tns listener?
Give the different types of rollback segments.
How to declare a local variable?
How to start a specific oracle instance?
How to create lov dynamically at runtime & attach to text field?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
