OraFAQ Forum: SQL & PL/SQL » Re: Looking For "Elegant" Solution

Blog
Search
Help
Members
Register
Login
Home

Home » SQL & PL/SQL » SQL & PL/SQL » Re: Looking For "Elegant" Solution

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Looking For "Elegant" Solution [message #40017]

Tue, 03 September 2002 21:29

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Here is an example of how to do a "pivot" or cross-tab. You would use this to turn the normalized data layout given in my previous response into a query result with columns such as:

contract_no
balance_200101
credit_limit_200101
...
balance_200112
credit_limit_200112

The key is to store the data in a normalized fashion and then de-normalize it (if necessary) in a query.

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

Report message to a moderator

Previous Topic:	Creating user and inserting data
Next Topic:	connecting from PLSQL to DB2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 09:54:04 CDT 2024