Re: Query..

Carlos wrote:
> Take a look at UNION ALL
>
> HTH.
>
> Carlos.

Though you could make it a lot easier by fixing the table as it is quite poorly designed. The table you describe should have only three columns.

CREATE TABLE demo (
name VARCHAR2(30),
lang VARCHAR2(1),
val NUMBER(3));

Think vertically ... not horizontally.

Every line of your code will break if you add another column the way you have it designed.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)