Home » SQL & PL/SQL » SQL & PL/SQL » Tabular view of normalized table?
Tabular view of normalized table? [message #4211] Tue, 19 November 2002 03:54 Go to next message
Andoni OConchubhair
Messages: 2
Registered: August 2002
Junior Member
Hello,

I have a table which holds the translations of string for my interface: Cols: StringId, LangId, String.
If there are 100 string in 3 languages there are 300 rows in the table.

How do I do a query so that I get a view which has the languages across the top and string ID's down the side, i.e. 1 row for each stringId and 1 column for each language. This would need to include nulls so I can spot missing strings.

My thanks in advance.

Report message to a moderator

Re: Tabular view of normalized table? [message #4215 is a reply to message #4211] Tue, 19 November 2002 11:18 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
See here for an example of how to "pivot" a table:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:766825833740

Report message to a moderator

Previous Topic: a subquery returned not exactly one row
Next Topic: moving data from one table to mutliple tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 06:10:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.