| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Get the time from remote server
"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
![]() |
![]() |