PL/SQL Help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: PL/SQL Help

  1. #1
    Join Date
    Nov 1999
    Posts
    226
    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

  2. #2
    Join Date
    Feb 2001
    Posts
    9

    Pl Give brief desc

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

  3. #3
    Join Date
    Nov 1999
    Posts
    226

    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
  •  


Click Here to Expand Forum to Full Width