Search text in Oracle DB; Returns all types of Oracle function where this text appears;

Select * from ALL_SOURCE  where TEXT LIKE '%Approval%'   

or 

Select * from dba_source where upper(text) like '%ENTER THE TEXT YOU WANT TO SEARCH HERE%'

[NS-30131] Initial setup required for the execution of installer validations failed.

Error installing Oracle client for Windows

setup.exe -ignorePrereq -J"-Doracle.install.client.validate.clientSupportedOSCheck=false"

https://orawiki.org/2016/10/11/initial-setup-required-for-the-execution-of-installer-validation-failed/