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