Is linking multiple Oracle schemas clean?

[jbullman]

If we use a command with a simple select statement that links tables from multiple schemas, does that involve any of the issues of linking multiple databases? The command looks like:

select name, street
from schema1.employee, schema2.address
where schema1.employee_id = schema2.employee_id

Thanks for your input.

Judith

Judith Ullman

http://www.innovativeinformation.com

Metro New York Crystal Decisions Training and Consulting Partner

 

[synapsevampire]

No, it should work fine.

Paste it in and run, although I'd suggest creating a View rather than pasting in SQL, it simplifies maintenance and allows for reusability.

-k