-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|