how to write oracle two instance information in single query?

Posted by rsaravanakumar on Stack Overflow See other posts from Stack Overflow or by rsaravanakumar
Published on 2010-03-18T09:42:25Z Indexed on 2010/03/18 9:51 UTC
Read the original article Hit count: 146

Filed under:

i using oracle 10g database, i installed two instance in my machine(dev and dev10g), i using query "select instance_name,status from v$instance" this query return one instance information but i need two (dev and dev10g) instance information, how i write a query. it is possible without using dblink. pls help me.

© Stack Overflow or respective owner

Related posts about Oracle