Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting sysdate across a DB link
Paul Moore wrote:
> DA Morgan <damorgan_at_exesolutions.com> writes:
>
> > Paul Moore wrote:
> >
> >> I'm trying to get the value of SYSDATE on a remote server.
>
> [...]
> >
> > I'd write a function on that machine to return it.
>
> I'd rather not have to do this. This is for a maintenance function
> across 100+ target databases, and I'd rather not have to install a
> custom function across all of the databases.
>
> If that's the only way, then fair enough. But I'll probably just do
> the query in a client using 2 separate connections if that's the case,
> and not bother with DB links at all...
>
> Thanks for the suggestion,
> Paul.
> --
> This signature intentionally left blank
If you have a db_link ... a simple bit of dynamic SQL will build the function on all 100 for you in a matter of seconds.
Daniel Morgan Received on Fri Feb 28 2003 - 18:59:50 CST