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
0-8537 should have 18-JUN-99
69281-8537 should have 10-sep -99
if any discrepance then
2345 - 20-jun-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 .