Subversion Repositories DevTools

SELECT an.note_id, an.NOTE_TITLE, an.NOTE_BODY, an.mod_date, usr.full_name, usr.user_email,
           an.mod_date ||' by '|| usr.full_name AS lastmod
  FROM ADDITIONAL_NOTES an,
           USERS usr
 WHERE an.pv_id = :PV_ID
   AND an.mod_user = usr.user_id
 ORDER BY an.note_id