Hi anuj.

It really depends on the format of the file. One method I've used against CSVs is the DIY$View approach. See:

http://www.oracle.com/oramag/webcolu...y_dynamic.html

If you do not know the internal format the only thing I can suggest is to use ODBC as a gateway to this data.

Good luck.