Home » SQL & PL/SQL » SQL & PL/SQL » Find list of proccedures having rule hint (oracle9i)
Find list of proccedures having rule hint [message #333720] Mon, 14 July 2008 04:29 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
How to find list of procedures having rule hint?

Thanks in advance,
0li

[Updated on: Mon, 14 July 2008 04:36]

Report message to a moderator

Re: Find list of proccedures having rule hint [message #333722 is a reply to message #333720] Mon, 14 July 2008 04:42 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Look in the DBA_SOURCE view, for all occurrences of RULE.
You'll probably want to use something like:
LIKE '%+%RULE
Re: Find list of proccedures having rule hint [message #333732 is a reply to message #333722] Mon, 14 July 2008 05:13 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
JRowbottom wrote on Mon, 14 July 2008 04:42
Look in the DBA_SOURCE view, for all occurrences of RULE.
You'll probably want to use something like:
LIKE '%+%RULE





Thank you very much.
Re: Find list of proccedures having rule hint [message #333736 is a reply to message #333732] Mon, 14 July 2008 05:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course, this search must be case insensitive and will give you false positives and false negatives.

Regards
Michel

[Updated on: Mon, 14 July 2008 06:18]

Report message to a moderator

Re: Find list of proccedures having rule hint [message #333743 is a reply to message #333736] Mon, 14 July 2008 05:43 Go to previous message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Yah, I am aware of it. Thanks Michel.


SELECT name, line, text FROM dba_source WHERE LOWER(text) like '%rule%'


[Updated on: Mon, 14 July 2008 05:44]

Report message to a moderator

Previous Topic: How to find duplicate rows.
Next Topic: How to dedicate USER1 for SID_INSTANCE 1
Goto Forum:
  


Current Time: Tue Dec 06 10:11:02 CST 2016

Total time taken to generate the page: 0.14019 seconds