Skip navigation.

How to get the version of the files?

vamsi kasina's picture

For Packages:

   SELECT text
   FROM   all_source
   WHERE  name = Upper('&package_name')
   AND line = 2;
For Other Files:
   SELECT af.subdir, 
          af.filename, 
          afv.version 
   FROM   ad_files af, 
          ad_file_versions afv 
   WHERE  af.file_id = afv.file_id 
   AND af.filename = '&file_name';