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 -------- ---------- ---------- ---------- --------
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 685ED920Received on Sat Jul 05 2003 - 00:46:50 CEST