Search Results

Hi

Just open a same sql session like you had one for the select statement and so something like this:


sqlplus -s xxxx/xxxx@$ORACLE_SID $a $b $c <<EOF
SET HEADING OFF
SET SERVEROUTPUT ON...

i am not sure about the sqlplus.

may be you can include set for echo off and linesize


set echo off
set linesize 150

There should not be any space between ret and = and yet you still have it!
Copy patse this!

ret=`sqlplus -s /nolog << EOF
connect $db_user/$db_pwd@$db_sid;
SPOOL output.txt;
set...

which is your OS? If solaris, please use nawk
Also, please use the updated code!

--ahamed

awk '/OrdAcctCycChg/ {print $1,substr($3,length($3),1)}' inputfile | while read a b
do
echo $a #your first variable value
echo $b #your second variable value
done

nawk '{print $1,substr($3,length($3),1)}' inputfile | while read a b
do
echo $a #your first variable value
echo $b #your second variable value
done

Yes, now that it works, you don't need the trace information no more.
Just remove set -xv from the beginning.

You need to assign values to these variables:

db_user
db_pwd
db_sid

I didn't understand.
The solution can be fit to your requirement. you can off course adjust/re-use it to match with.

If you are sure the last character would always be a digit and want to pass...

awk -F\| '{for(i=0;++i<=NF;) if($i ~ /Acct/) print substr($i,6)}' infile--

Did you try Sed or other awk solutions..?
grep -oE '[0-9]{9,}' inputfile # assuming minimum of 9 digits for Acc numbers

Simple grep solution
grep -o 'Acct [0-9]*' inputfile
# Or through Sed
sed -n 's/.*Acct \([0-9][0-9]*\).*/\1/p' inputfile

Expecting your file is a plain text so try this...

awk -F\| '{for(i=0;++i<=NF;) if($i ~ /Acct/) print $i}' infile