download-verify-oracle.xql
DB Query file
Related Files
- packages/download/www/download-verify.tcl
- packages/download/www/download-verify.adp
- packages/download/www/download-verify-postgresql.xql
- packages/download/www/download-verify-oracle.xql
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?> <queryset> <rdbms><type>oracle</type><version>8.1.6</version></rdbms> <fullquery name="revision_info_select"> <querytext> 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 </querytext> </fullquery> </queryset>