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: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 13 Feb 2006 06:01:08 -0500
Message-ID: <5c6dnZ9IkuBo-23eRVn-vw@comcast.com>

"Arto Viitanen" <arto.viitanen_at_csc.fi> wrote in message news:43f03695$0$10076$ba624cd0_at_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

do you have examples of what you're proposing?

++ mcs Received on Mon Feb 13 2006 - 05:01:08 CST

Original text of this message

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