oracle8.1.6 select da.archive_id, da.repository_id as repository_id, da.archive_name, da.summary, dar.revision_id, dar.file_name, dar.version_name, round(dbms_lob.getlength(dar.content)/1024) as file_size from download_archives_obj da, download_arch_revisions_obj dar where da.archive_id = dar.archive_id and dar.revision_id = :revision_id $approval