How do I find a trigger with only partial name?
I have been asked to look for a trigger in Oracle 8 database. I have beginning of trigger name only (not all of it.) How do I do this ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for quick response!
TPW4498 - I appreciate the points but a split is in order here.
slightwv and I posted essentially the same answer virtually simultaneously
slightwv and I posted essentially the same answer virtually simultaneously
I'm OK with it: First correct post should get the points.
ASKER
I will split points, I just don't know how to do that.
In this question it has already been done for you. In the future, pick the main post you want to accept then click 'Accept Multiple Solutions' and you will have to opportunity to select as many other posts and adjust the points as you want.
select * from all_triggers where trigger_name like '%YOUR_NAME%'