Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is there an SQL to create a view that will normalize a denoramlized table?
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