Subversion Repositories DevTools

/* Module components */
SELECT rc.PV_ID, 
           REGEXP_REPLACE(rc.file_path, '[/\\]', '/') AS FILE_PATH, 
           rc.FILE_NAME, 
           rc.BYTE_SIZE,
           rc.CRC_CKSUM,
           rc.CRC_MODCRC
  FROM RELEASE_COMPONENTS rc
 WHERE rc.PV_ID = :PV_ID
 ORDER BY UPPER(rc.FILE_PATH), UPPER(rc.FILE_NAME) NULLS FIRST