Trigger in Package

[hemalatha]

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

[Pinakin]

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.