Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: <tedchyn_at_yahoo.com>
Date: Thu, 29 Jul 1999 22:03:52 GMT
Message-ID: <7nqj41$96r$1@nnrp1.deja.com>


In article <1HYn3.4545$x7.228281_at_newscene.newscene.com>,   ramdan_at_mailexcite.com (tony) wrote:
> 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!
>

ramdan, looks you have create 24 views
create or replace views v_hour1 ( ) as select id, date, hour1 etc Ted Chyn

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 29 1999 - 17:03:52 CDT

Original text of this message

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