1. Can we use triggers in packages? If not why
2. How we can tell to the Oracle, which index to use. Please give code if necessary
Printable View
1. Can we use triggers in packages? If not why
2. How we can tell to the Oracle, which index to use. Please give code if necessary
1. Can we use triggers in packages? If not why
Trigger is the code that is executed when a specific event, like : insert, update or delete, occurs on an object. As such you cannot call triggers from packages. To execute the trigger code in your package you can put down that code into a function or procedure and then call that code from your trigger and/or package.
2. How we can tell to the Oracle, which index to use. Please give code if necessary
Consider the following example :
select /*+ INDEX(table_name index_name1 index_name2...) */ column1, column2 ...
Hope this will help.
Regards,
Pinakin.