1. How many triggers can we write on table.
2. How to debug a package .
3. What is the maximum size of a pl/sql block.
4. How to encrypt a functions and procedures.
Printable View
1. How many triggers can we write on table.
2. How to debug a package .
3. What is the maximum size of a pl/sql block.
4. How to encrypt a functions and procedures.
1.I think Total 12 Type Trigger on a table .
2.For ur second question follow this [URL="http://www.adp-gmbh.ch/ora/plsql/debug.html"]link[/URL]
3.There is no limit on size of pl/sql block
4.Follow [URL="http://www.databasejournal.com/features/oracle/article.php/3382331"]this[/URL]
my undersgtanding is u can define any number of triggers and all will fire on the event.