: : while 1 sqlplus -s $5/$6@$7 @c.sql $3 >> fc1 end
When I tail -f fc1, I get
old 1: select count(*) from v$session a where a.username='&1' and a.status='AC TIVE' new 1: select count(*) from v$session a where a.username='test' and a.status='ACTIVE'
> : > : > while 1 > sqlplus -s $5/$6@$7 @c.sql $3 >> fc1 > end
> When I tail -f fc1, I get
> old 1: select count(*) from v$session a where a.username='&1' and > a.status='AC > TIVE' > new 1: select count(*) from v$session a where a.username='test' and > a.status='ACTIVE'
On 2008-02-03 07:23:35 +0100, zw <MPC8...@gmail.com> said:
> old 1: select count(*) from v$session a where a.username='&1' and > a.status='ACTIVE' > new 1: select count(*) from v$session a where a.username='test' and > a.status='ACTIVE'
> 0
... make yourself familiar with the "show" and "set" options of the sqlplus command. Read the "Oracle SQL*Plus User's Guide and Reference"... -- cul8er
> Only 4 and a half years old! The worst case I've seen was 14 years.
> Sadly, this sort of thing is getting more and more common.
> Eric
> --
> ms fnd in a lbry
It's sad, but isn't it merely ignorance or even just a mistake, rather
than stupidity? Ignorance is fixable, everyone makes mistakes,
especially with new features (like being able to answer 14 year old
messages, or search engines directing into forum knowledge bases with
no expire dates). My inner optimist wants to guide the desire of
these people to help towards a positive goal, but I can't quite see
how.
