Help w/Normalized VIEW
From: Jon Derman <derman_at_mindspring.com>
Date: 1997/12/14
Message-ID: <3493db10.39103204_at_news.mindspring.com>#1/1
Date: 1997/12/14
Message-ID: <3493db10.39103204_at_news.mindspring.com>#1/1
If I have a table that looks something like this:
...can I simply create a normalized VIEW of that table that looks
something like this (with 3 times as many rows as the original)?:
Can someone please show me example SQL for creating such a VIEW?
Thanks.
SSN VARCHAR2(9)
COURSE1 VARCHAR2(6)
COURSE2 VARCHAR2(6)
COURSE3 VARCHAR2(6)
SSN VARCHAR2(9)
COURSE VARCHAR2(6)