Re: HELP ???

In article <YegK6.7237$yw.292732_at_news20.bellglobal.com>, Serge Nantel <snantel_at_virtuo-cio.com> writes:
>Hi,
>
>Its possible to query 2 separate instance with the one connection?
>
>Like if I am connected to instance number 1 and I do a select for instance
>number 1 to query instance number 2.
>

Forgive me if I misunderstand, but... 2 instances of the same database? That wouldn't make any sense. The underlying data would be the same, so there would be no point in querying it from 2 different instances.

If you mean querying from one database while you're connected to another, no problem. Use a database link, sort of like this...

create public database link orc2 as
connect to scott identified by tiger
using 'ORC2';

select t.species
from turtle t
where t.shelldiameter >

    ( select c.max(shelldiameter)
      from clam_at_orc2 c
    );

(Haven't checked the syntax, may be slightly off.)

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net