Search Results

Sorry team , let me provide more info..
1.Firstly, it checks for the sql db connection. If connection is success it will execute script/file , if not it prints connection failed and wont execute any...

Team,
Im new to shell scripting please help in below issue:
Considering scenario i have 1.sql,2.sql,3.sql and 4.sql . If my second script fails my loop should come out and should not execute 3.sql...

When i run, im getting below error:

SP2-0734: unknown command beginning "echo "Exec..." - rest of line ignored.
SP2-0734: unknown command beginning "SQLFILE=/h..." - rest of line ignored.

I tried as below constructing for loop outside SQLplus to execute all .sql files which resides in /home/*.sql files.
Throwing an error: UNEXCPETED EOF.

#!/bin/bash
cat /dev/null > output.log...

Hello ,

Im calling every single file inside my script like 1.sql,2.sql so on it looks so tedious. I want to replace with for loop where every file gets executed. When i use for loop im getting...