Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> thanks here is solution
here is the first table tab24row (I did 4 rows instead of 24 for simplicity)
NAME READDATE READHOUR READING ---------- ----------- --------- --------- system 19-feb-1999 1 1000 system 19-feb-1999 2 1500 system 19-feb-1999 3 2000 system 19-feb-1999 4 1400
this is how other table: tab1row looks like
NAME READDATE READING1 READING2 READING3 READING4 this it the sql:
INSERT INTO TAB1ROW (NAME,READDATE,READING1,READING2,READING3,READING4)
(select t1.name, t1.readdate, t1.reading HOUR1 , t2.reading HOUR2,
t3.reading HOUR3 , t4.reading HOUR4
from tab24row t1, tab24row t2, tab24row t3, tab24row t4
where t1.name = 'system'
and t1.readhour = 1 and t2.name = t1.name and t2.readhour =2 and t3.name = t1.name and t3.readhour = 3 and t4.name = t1.name and t4.readhour = 4);
and this is result
SQL> SELECT * FROM TAB1ROW; NAME READDATE READING1 READING2 READING3 READING4 system 19-feb-1999 1000 1500 2000 1400
thanks for suggustions. Received on Fri Feb 19 1999 - 13:56:41 CST