Once upon a time… I needed to check in the source of which objects a particular character string was included.
LONG
(the pun!…) story short, non of the {USER|ALL|DBA}_SOURCE
views give you a chance to search in the source of the views.
“Well, why is that a problem?!” – I hear you saying – “Don’t you know the {USER|ALL|DBA}_VIEWS
views views (wait, one views too many)?”
O my, but of course! There’s a column named TEXT
in them with the source of the views! Let’s try that: Czytaj dalej