PL/SQL Help

[puneet]

Hi

I have a table like this

REG TIMESTAMP
--------- ---------
0 18-JUN-99
8537 10-SEP-99
69281 04-OCT-99
71222 05-OCT-99
73340 06-OCT-99
75139 07-OCT-99
76848 08-OCT-99
79014 09-OCT-99
80474 10-OCT-99

I want to write a PL/SQL program to check whether the REG between the 1 st and the 2nd row have date of 18- JUN -99 or not and then 2 and 3 rd row to have 10-SEP-99 . If some REG do not have that date then what date do they have

EX

0-8537 should have 18-JUN-99
69281-8537 should have 10-sep -99

if any discrepance then
REG timestamp
2345 - 20-jun-99

Please let me know the program for this
regards

[komes]

Sorry
I unable to understand ur question. Can u tell me in briefly
thanx
bye
komes

[puneet]

Hi

I have a table with REG numbers and their dates .What I did was create a summary table of the main table which has all the details like this :


REG TIMESTAMP
--------- ---------
0 18-JUN-99
8537 10-SEP-99
69281 04-OCT-99
71222 05-OCT-99
73340 06-OCT-99
75139 07-OCT-99
76848 08-OCT-99
79014 09-OCT-99
80474 10-OCT-99


using select max(reg) trunc(timestamp) from table A
group by trunc(timestamp)
order by trunc(timestamp) ;



The table A has all REG numbers and dates along with it .

I need to write a program where the details of the REG number will be taken from table B . and run against table A to get the dates.Timestamp is the registration date of the user. so to ensure that between 0 and 8537 all users registered on 18-JUN-99.

Eg REG between 0 and 8536 should have 18-JUN-99 as timestamp if not then show those REG and timestamp and then for 8537 and 69281 to have 10-SEP-99 in table A .


Hope it is clear .

regards