Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select table depends on company

1006200Apr 29 2013 — edited Apr 29 2013
We have a ERP with parametrized company tablenames like this example below:

customer001 is a company 001 customer's table
customer002 is a company 002 customer's table

We are trying to find a way that make oracle views full compatible with all companies, to avoid to change the code everytime, or duplicate the same view for each company.

I spend some hours trying to solve this unsuccessful.

Edited by: user12228294 on 29/04/2013 17:39
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2013
Added on Apr 29 2013
5 comments
101 views