Hello everyone,
I am having an application that copies file from user to DB filesystem and then opens it as external table... The next data flow is to copy data from this external table and perform some actions on it.
My question is - I have to report row number, where some error occured and this row number must match the physical row number in file... Can I rely on the fact, that if I do something like
SELECT rownum, t.* FROM ext_table t
, the ROWNUM will correspond to row number in file? I'm just asking because its not documented anywhere.
I'm running Oracle XE, but we will probably move to 11g (or something never) in the future.
Thanks
Adam