Search Results

With an example of your input file I get this output:

$ cat file
Other line
Other line
Other line
SQL> update <table1> set <value1> = '*****';
update <table1> set <value1> = '*****'
*...

#!/bin/bash
#tested with bash 4

content=$(<file)
while [[ $content =~ Elapsed ]]
do
c=${content#*Elapsed}
case "${content%%Elapsed*}" in
*SQL*ERROR*)
echo...

Try:
awk '/^SQL/{s=$0;next}{s=s RS $0} /^ERROR/{f=1} f && /^Elapsed/{print s; f=0}' file

I don't think the cd will stop it from working.

The export won't hurt it, but I don't think it's doing what you wanted either. If ORACLE_HOME wasn't set to anything, exporting it won't figure out...