Well its known that procedure would be required
but the requriement dosent allow to work in PL/SQL
so just the sujjestions were welcomed if anything could be done in SQL
about taking an course in SQL .its not forum to answer such question
It was just that the exact forum was not known where the
questions could be posted.
But had quite nice responses here.