Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: A non-relational prob

Re: A non-relational prob

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 19 Mar 2001 21:25:36 -0800
Message-ID: <3AB6E9D0.22096296@exesolutions.com>

> <snip>
> Now, the question: how would I desing an sql select statement, that,
> given the language and the country of a user, returns the correct text
> in a _single_ line for a text id?

Do you have a table of users with that user's default language and country?

If so a simple join or outer-join should turn the trick.

Daniel A. Morgan Received on Mon Mar 19 2001 - 23:25:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US