#!/bin/bash
cat textfile.txt |while read Name
do sqlplus -s <a href="mailto:userid/password@db_name">userid/password@db_name</a> &gt; output.log &lt;&lt;EOF
set verify off
set heading off
select customerid  
  from customers  
 where customername like '%${Name}%';
/ exit EOF

Korn Shell Ref

Ready for Action?

LET'S GO!
Copyright 2024 IT Remote dot com
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram