-
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
-
Pl Give brief desc
Sorry
I unable to understand ur question. Can u tell me in briefly
thanx
bye
komes
-
Clarification
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|