Dear all,
I have some tables that have LOB BFILES out of line.
How can I use DBMS_LOB to see the directory and file name in combination wih select of the rows in the table including BFILE.
Using DBMS_LOB.FILEGETNAME you should have both the file name and the directory the file resides.
Any idea to get guery like select for rows including column that have pointer to BIFILE.

Thanks hamhey