SYSDATE of remote database [message #18730] |
Tue, 12 February 2002 15:36 |
Sumesh
Messages: 3 Registered: February 2002
|
Junior Member |
|
|
Hi All,
How to get the SYSDATE of a remote database without creating any objects in the remote database? SELECT SYSDATE FROM DUAL@db_link returns the local database timestamp.
Thanks in Advance.
|
|
|
Re: SYSDATE of remote database [message #18731 is a reply to message #18730] |
Tue, 12 February 2002 16:30 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
I am not aware of a way to get a remote sysdate without building a function at the remote that returns sysdate.
All documentation I have seen says that sysdate is always evaluated within the local context.
|
|
|
|
|