I need to put together the information of two tables in different schemes that are in different hosts....
1. I do not know if the best will be to do a join or Union
2. How the command shoudl go?
Create View view_name [column name] as
select [column_name] from host.tablename
how should indicate the procedence from different shemes...
3. should i create it under SQL*Plus?
I know my questions are basic but i want to make sure we are doing the appropiate.
Thanks.
1. I do not know if the best will be to do a join or Union
2. How the command shoudl go?
Create View view_name [column name] as
select [column_name] from host.tablename
how should indicate the procedence from different shemes...
3. should i create it under SQL*Plus?
I know my questions are basic but i want to make sure we are doing the appropiate.
Thanks.