difference of sqlplus in hp than sun

From: victor tsien <v.tsien_at_comcast.net>
Date: Fri, 04 Jul 2003 22:46:50 GMT
Message-ID: <utnNa.38653$fG.21543_at_sccrnsc01>



[Quoted] I have a script in unix. However, different results came after running in two machines. Anybody know why? The script is very simple:

#!/usr/bin/ksh
sqlplus scott/tiger << EOF
spool result.txt
select * from v$session where username ='scott'; spool off
exit
EOF

in HP UX, the result is:
SQL > select * from v$session where username ='scott'; In sun solaris:
SQL > select * from v$session where username ='scott'; SADDR SID SERIAL# AUDSID PADDR -------- ---------- ---------- ---------- --------
6861207C          1          1          0 685EAFE0
686129EC          2          1          0 685EB3A0
6861335C          3          1          0 685EB760
68613CCC          4          1          0 685EBB20
6861463C          5          1          0 685EBEE0
68614FAC          6          1          0 685EC2A0
6861591C          7          1          0 685EC660
6861628C          8          1          0 685ECA20
68616BFC          9        752          0 685ED920
Received on Sat Jul 05 2003 - 00:46:50 CEST

Original text of this message