"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
There is a chance that from where you are invoking sqlplus is having OS date different to that of the date set in the Unix machine where database actually resides.
Eg : There are 2 Unix machines A & B
B is where database(ABCD) resides..
A is where you invoke SQL+ as
In A it is set as '5 feb 2003'
In B it is set as '10 Feb 2003'.
Then when u give select sysdate from dual;Output would be '10 Feb2003'
But when you give
5 feb 2003.
Confirm from select host_name from v$instance;
I don't know if I am throwing light or blowing light.
Jus' thinking from a different angle.that's all..
With lots of fun,
Make that 4 pages of wasted space...
Originally posted by stmontgo
hilarity ensues as a one post reply answer gets exploded to 3 pages of wasted space
Click Here to Expand Forum to Full Width