Re: Beginner's ?

Thank! But it doesn't work. The process is halt when execute: members=$(sqlplus -s <uname>/<pass> @$tempfile)

Any idea?

Jack

Gary O'Keefe wrote:

> A quick and dirty solution would be:
>
> #!/usr/bin/bash # or whatever is appropriate for your setup
>
> tempfile="tempfile.sql"
> echo set heading off > $tempfile
> echo set feedback off >> $tempfile
> echo select member from v\$logfile";" >> $tempfile
> echo exit >> $tempfile
>
> members=$(sqlplus -s <uname>/<pass> @$tempfile)
> for member in $members
> do
> # do stuff
> echo $member
> done
> rm $tempfile
>
>
Received on Wed Jul 21 1999 - 19:08:02 CDT