Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 526
  • Last Modified:

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 ?
0
TPW4498
Asked:
TPW4498
  • 3
  • 3
  • 2
2 Solutions
 
sdstuberCommented:
select * from all_triggers where trigger_name like 'YOUR_NAME%'
0
 
slightwv (䄆 Netminder) Commented:
select trigger_name from dba_triggers where trigger_name like 'SOME_NAME%';
0
 
sdstuberCommented:
or, if you might be missing part of the beginning you can wildcard before it too

select * from all_triggers where trigger_name like '%YOUR_NAME%'
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
TPW4498Author Commented:
Thanks for quick response!
0
 
sdstuberCommented:
TPW4498 - I appreciate the points but a split is in order here.

slightwv and I posted essentially the same answer virtually simultaneously
0
 
slightwv (䄆 Netminder) Commented:
I'm OK with it:  First correct post should get the points.
0
 
TPW4498Author Commented:
I will split points, I just don't know how to do that.
0
 
slightwv (䄆 Netminder) Commented:
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.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now