Reading file and passing parameter to Oracle SQL to fetch the data.
#!/bin/sh
rm -r FinalDepInfo.txt
for row in `cat myDep.txt`
do
rm -r FinalDepInfo.txt
for row in `cat myDep.txt`
do
a=$(C:/oraclexe/app/oracle/
spool mytest.txt
select first_name, last_name, email
from employees
where department_id = $row;
spool off;
exit;
QUERY);
less mytest.txt >> FinalDepInfo.txt
done;
from employees
where department_id = $row;
spool off;
exit;
QUERY);
less mytest.txt >> FinalDepInfo.txt
done;
Reading file line by line
#!/bin/sh
while read line
do
echo $line
done < FinalDepInfo.txt
while read line
do
echo $line
done < FinalDepInfo.txt
Best Casino in L.A. to Play Slots at MapYRO
ReplyDeleteLooking for 사천 출장안마 a great casino to play slots online at? of 원주 출장안마 these casino that 제주 출장마사지 offers 아산 출장마사지 online 당진 출장샵 slots at MapYRO and Casino Player Ratings for November