Yes I did ... but why not create a tiny view in a schema that you can
reference ?
"Paul Moore" <paul.moore_at_atosorigin.com> wrote in message
news:u1eo9g8m.fsf_at_morpheus.demon.co.uk...
> "Telemachus" <telemachus_at_ulysseswillreturn.net> writes:
>
> > it works with full views - but my clocks are synchronized so your
mileage
> > may vary.
> > SQL> CREATE VIEW MOO AS SELECT 1 AS SILLY_HEADER,SYSDATE AS MOOTIME FROM
> > DUAL;
> >
> > View created.
>
> Did you need to create that view on the remote server? If so, having a
> view on the remote server is just as much (or as little, depending on
> how you look at it...) of a problem as defining a function on the
> remote server.
>
> Thanks for the suggestion,
> Paul.
> --
> This signature intentionally left blank
Received on Mon Mar 03 2003 - 04:28:02 CST
