I would help if it was MS SQL. I don't know Oracle and PL/SQL. Also you need to be more detailed on the table structure (column etc.)