-
How to select sysdate of remote database
I want to fetch the sysdate of a remote database using dblink, I used the following sql :
select sysdate from dual@remote_db_link
But this fetches me local server date and not of the remote one.
Is there a sql to do this, since i can't write procedures in each remote machines which will be called by local sever to do the same task.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|