Transpose problem...
From: Ste <stro_at_solari.it>
Date: 23 Jul 2002 02:57:28 -0700
Message-ID: <3b2044af.0207230157.1253fe0f_at_posting.google.com>
Date: 23 Jul 2002 02:57:28 -0700
Message-ID: <3b2044af.0207230157.1253fe0f_at_posting.google.com>
Hi all,
Where CODE is my primary key.
I've played around DECODE but seems to solve the reversed problem.
I've got this problem. My original table is:
CODE | STOP_1 | STOP_2 | STOP_3
001 | ABC | DEF | GHI
002 | LMN | OPQ | RST
I'de like to get a view that gives the result in this form:
CODE | STOPS_LIST |
001 | ABC |
001 | DEF |
001 | GHI |
002 | LMN |
002 | OPQ |
002 | RST |