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
Oracle
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