This content has been marked as final. Show 1 reply
It is only stored if you keep history for all values for your variable.
SELECT * FROM SNP_VAR_DATA WHERE VAR_NAME = 'YOUR_VARIABLE' ORDER BY FIRST_DATE DESC;
However I recommend you to store the filenames in a table yourself at loading time. I explained you how to do that in this thread : how to Load file name in to Oracle table column
Hope it helps.
PS : If you found answers helpfull / correct, please flag it (on the right of the answers). It ensure that contributers are awarded the points they deserve and that future readers will find the right answer directly.