1,通过操作系统命令,需要有OS用户:
bash-3.2$ strings -a $IEX_TOP/patch/115/import/US/iexmdmsg.ldt | grep '$Header'
# $Header: iexmdmsg.ldt 120.88.12000000.15 2008/12/08 18:05:52 ehuh ship $
2,通过SQL,需要DB用户:
SELECT '$'
|| af.app_short_name
|| '_TOP'
|| '/'
|| af.subdir
|| '/'
|| af.filename
filename,
MAX (afv.VERSION) VERSION
FROM ad_files af, ad_file_versions afv
WHERE af.file_id = afv.file_id
AND af.filename LIKE TRIM ('&filename') || '%'
GROUP BY '$'
|| af.app_short_name
|| '_TOP'
|| '/'
|| af.subdir
|| '/'
|| af.filename;
FILENAME
VERSION
$IEX_TOP/patch/115/import/US/iexmdmsg.ldt
120.88.12000000.15