Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Get the time from remote server
Mark C. Stock wrote:
> : > How I can get the time what is on that server, is there any solution...
> :
> : select sysdate from dual_at_remote;
>
> nope. sysdate is evaluated locally
But what about sysdate evaluated in PL/SQL block? Or if that fails, using instead of trigger on a view at remote site?
-- Arto Viitanen, CSC Ltd. Espoo, FinlandReceived on Mon Feb 13 2006 - 01:34:45 CST