Find Replace

I want to do a simple find replace of a string in one line for all the files in a Unix directory Useful when the Oracle DBA has to update a lots of SQL or shell scripts. Example of a find replace: ~/sql directory has thousands of SQL files and I’d like to find out […]

MassExecuteSQL

I have some standard SQL that I want to run against multiple databases on a single server to help me report informations or diagnose problems. This script intended for Oracle DBA, executes an sql statement on all Oracle 18c databases running on a Unix server. First example:       On all databases. Second example: On […]