Help w/Normalized VIEW

If I have a table that looks something like this:

SSN             VARCHAR2(9)
COURSE1         VARCHAR2(6)
COURSE2         VARCHAR2(6)
COURSE3         VARCHAR2(6)

...can I simply create a normalized VIEW of that table that looks something like this (with 3 times as many rows as the original)?:

SSN             VARCHAR2(9)
COURSE          VARCHAR2(6)

Can someone please show me example SQL for creating such a VIEW?

Thanks. Received on Sun Dec 14 1997 - 00:00:00 CST