Search Results

You could use a grouping command (http://www.gnu.org/software/bash/manual/bashref.html#Command-Grouping) form:
for file in *.sql
do
{
echo "create or replace"
...

make sure you support your local charities ...
echo "create or replace" > /tmp/sqlfile
cat yourfile.sql >> /tmp/sqlfile
echo "/" >> /tmp/sqlfile
mv /tmp/sqlfile yourfile.sql

Try below.


for file in *.sql ; do
awk 'BEGIN{printf "create or replace "}{print $0}END{print "/"}' $file > temp
mv temp $file
done

Do you need it on all the lines of the *.sql or only at the start and end of the file ?
For all the lines, here is the solution

sed -e 's/^/create /g' -e 's/$/ \//g' file > new-file

try below if


if [ `egrep -c "$names" ${FILENAME}` -eq 0 ]; then
echo "file not present"
else
echo "file present"
fi

To start with you are storing the sqlplus result under names variable but using $name in egrep

Hi, I add a clarification: if you apply this solution to the error output of a script may be necessary to redirect execute a redirect

./script.sh 2>&1 | awk -F' |:' '{print $4}'

awk -F' |:' '{print $4}' file

grep -o [0-9]* file

awk -F'[ :]' { print $(NF-1) } ' file

use "cut" command

Which database? I see sqlplus. Oracle has a facility to map files as tables, but very much for the DBA to set up and control. There is bcp and similar tools for SQL Server and Sybase, DB2 has a...

Your sample script is wrong on so many points i don't even know where to start:

#!/bin/bash
#SCRIPT: method2.sh
#PURPOSE: Process a file line by line with redirected while-read loop.
...

still not sure what exactly you need.!!!

where does $Line in your script comes from?

Assuming that the file content is a file name, something like this should be enough. I assume that...

RULES OF THE UNIX AND LINUX FORUMS

For the latest version of the community rules (the official community rules page), please visit here. (https://www.unix.com/misc.php?do=cfrules)


No flames,...