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