What are triggers? How many triggers you can have on a
table?
Answer Posted / shanky
Triggers are PL/SQL blocks which are executed implicitly
based
on database events.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is dbms and its application?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
What is the maximum length of an extended property?
Explain about normal forms?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What are data modelling techniques?
In which database can extended stored procedures be added?
Explain about post-relational databases?
How to generate OIDS
How to use timestamp datatypes
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How can I detect whether a given connection is blocked?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Write short notes on manual refreshes.
How can you fix a poorly performing query?