Re: difference of sqlplus in hp than sun
Date: Fri, 04 Jul 2003 17:29:12 -0700
Message-ID: <qZoNa.119882$MJ5.46826_at_fed1read03>
victor tsien wrote:
> 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
>
>
You have WEIRD results all around.
FWIW - V$SESSION has many, many more columns than the 5 displayed.
I suspect that SCOTT might even have a private synonym for V$SESSION.
In the future ALWAYS include Oracle Version(s)!
Received on Sat Jul 05 2003 - 02:29:12 CEST