| to find sysdate of remote database (merged 3) [message #390938] |
Tue, 10 March 2009 06:48  |
gauravpuri2002
Messages: 24
Registered: October 2007
Location: Bangalore
|
Junior Member |
|
|
Hi,
Is there is any way to find sysdate of remote database.
I am using :-
select sysdate from dual@db_link.
here this db_link links to remote database.
But this is not working as its giving date of local server.
Regards
Gaurav
|
|
|
|
|
|
|
|
| Re: to find sysdate of remote database (merged 3) [message #390947 is a reply to message #390938] |
Tue, 10 March 2009 07:19  |
 |
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Create a function in your remote database that returns the date and call it like:
SQL> create function f return date is begin return sysdate; end;
2 /
Function created.
SQL> select f@mika from dual;
F
-------------------
10/03/2009 13:18:16
1 row selected.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
