Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Get the time from remote server

Re: Get the time from remote server

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Mon, 13 Feb 2006 09:34:45 +0200
Message-ID: <43f03695$0$10076$ba624cd0@newsread.funet.fi>


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, Finland
Received on Mon Feb 13 2006 - 01:34:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US