Getting sysdate across a DB link

From: Ashish Sahasrabudhe <asahasrabudhe_at_weightwatchers.com>
Date: Mon, 26 Jan 2004 08:14:26 -0800
Message-ID: <F001.005DE269.20040126081426@fatcity.com>

Content-Type: text/plain;
charset="iso-8859-1"

I'm trying to get the value of SYSDATE on a remote server. I have a database link to the server, but I'm not sure how to force SYSDATE to be evaluated on the remote machine.

Following query gives same results, both dates are same.

select sysdate local_date, remote_date from ( select sysdate remote_date from dual_at_remote_db)

How can this be done?

Thanks

------_=_NextPart_001_01C3E427.A3B10250
Content-Type: text/html;
charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Getting sysdate across a DB link</TITLE>
</HEAD>
<BODY>

I'm trying to get the value of SYSDATE on a remote server. I have a
 database link to the server, but I'm not sure how to force SYSDATE to
 be evaluated on the remote machine.


Following query gives same results, both dates are same.


select sysdate local_date, remote_date from ( select sysdate remote_date from dual_at_remote_db)


How can this be done?


Thanks


</BODY>
</HTML>

------_=_NextPart_001_01C3E427.A3B10250--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ashish Sahasrabudhe
  INET: asahasrabudhe_at_weightwatchers.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jan 26 2004 - 10:14:26 CST