Re: Using a variable to create a table name
> Right now I have 269 tables per language with the location by country
> with the equivalent English title if there is one.
269 tables sounds crazy. 269 tables per language is much much crazier. I'll assume you meant 269 tables, one per language.
The question is, what problem do you expect to solve by having 269 tables rather than one master `countries` table with 269 rows, one per country?
> I need next to get a grouping per 250 countries
What does that mean? A grouping of what? To what purpose?
> I could go through each language table,
"Go through" means what exactly?
> form a table by language-country
Why in the world are you creating so many tables?
> then join each table by the English title if there is one. If no English title, it's not included in the join
Join in what query, with what purpose.
You're proposing to create hundreds of tables. To what purpose? What are you trying to accomplish? In all this so far, can't make out any elements of sound database design. Please try to formulate the informational problem you are trying to solve, without reference to table formation.
Subject
Written By
Posted
Re: Using a variable to create a table name
October 26, 2017 04:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.