hello
I am currently working with a Database with Multiple Schema's . Each schema represents a branch. Hence all objects are identical in name. So we have now close to 10 branches. when a new branch is opened we have another schema created. We have to consolidate the data from all these branches for different business requirements. for which there are views created accessing the branches
for example
customer_master_view will be like
select customer_no, customer_name, customer_add1 from branch1.customer
Union
select customer_no, customer_name, customer_add1 from branch2.customer
Union
select customer_no, customer_name, customer_add1 from branch3.customer
Union
select customer_no, customer_name, customer_add1 from branch3.customer
and so on ..
instead of this, is there a way where we can create this views dynamically
Need help and guidance on this
Thank you all
Saravanan