What's in 'Find Database Object' the difference between
Search for %pattern% AND
All Source Lines
In which area's does Search for %pattern% search for, if not in All Source Lines …?
oracle-sql-developer
What's in 'Find Database Object' the difference between
Search for %pattern% AND
All Source Lines
In which area's does Search for %pattern% search for, if not in All Source Lines …?
Best Answer
I'm going to answer your question based on version 18.2.
Searching source code in an Oracle Database via SQL Developer:
We automatically wildcard your search string - so you can search db object names, like tables named 'EMP' and also look for that string in your database code. We also make sure the case of the text isn't an issue.
Now, what do we consider 'source code?'
I talk about the search feature here and provide a video demo.