Shell Programming and Scripting

some code...
for file in `ssh user@10.200.200.10 'find /u01/bea/madeup/Images -name "*.jpeg" -mtime -1'`
do
scp user@10.200.200.10:${file} /oraworking/madeup/images/orig/
done
...more code

for file in `ssh user@10.200.200.10 'find /oracle/product/db/10gR2/bin/sqlplus -s /nolog  <<EOF  #Find is just going to try and find something in '/oracle/product/db/10gR2/bin/sqlplus' so this is wrong!

conn / as sysdba

set heading off
set feedback off
set pagesize 0
set linesize 30000
set trimout on
SELECT f.file_path||'/'||f.file_name
FROM fileupload f
INNER JOIN imagelog i
ON f.id = i.fileupload_id;'

EOF`

do
if [ -f ${file} ]
then
        echo "Skipping $file file..."
continue
fi

scp user@10.200.200.10:${file} /oraworking/madeup/images/orig/

done
...more code

for i in `cat list` do ssh user@10.200.200.10  "find path -name "$i" >> file
done

for file in `ssh user@10.200.200.10 find

${ORACLE_HOME}/bin/sqlplus -s /nolog  <<EOF

conn user/user
SET WRAP OFF
SET HEADING OFF

SELECT f.file_path||'/'||f.file_name
FROM fileupload_index@tardev1 f
INNER JOIN imagelog@tardev1 i
ON f.id = i.fileupload_id
WHERE f.file_name IS NOT NULL;

EOF
-type f`

do
scp user@10.200.200.10:${file} /oraworking/madeup/images/orig/
done

some code...

IMG_OUT=`${ORACLE_HOME}/bin/sqlplus -s /nolog  <<EOF

conn user/password

set feed off
set head off
set pages 0
@getimages
EOF`

echo "${IMG_OUT}" >> list

for i in `cat list`
do scp  csuser@10.202.200.11:${i} /oraworking/madeup/images/orig/
done

...more code