Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Is there an SQL to create a view that will normalize a denoramlized table?

Is there an SQL to create a view that will normalize a denoramlized table?

From: tony <ramdan_at_mailexcite.com>
Date: 29 Jul 1999 08:31:04 -0500
Message-ID: <JHYn3.4549$x7.228281@newscene.newscene.com>

we have a table that is normalized 24 hourly reading in one row

id date hour1 hour2 .. hour24

we need to create a view that is normalized.

id date hour1
id date hour2

any help please Received on Thu Jul 29 1999 - 08:31:04 CDT

This message: [ Message body ]
Next message: Will Bailey: "Re: Oracle #1? Then why are these still missing..."
Previous message: Titus Leskien: "rowtype assignment in trigger"
Next in thread: Steven Franklin: "Re: Is there an SQL to create a view that will normalize a denoramlized table?"
Reply: Steven Franklin: "Re: Is there an SQL to create a view that will normalize a denoramlized table?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US