How contents are stored in BLOB and BFILE columns
763572May 31 2010 — edited May 31 2010Hi All,
Currently I am working on project where i need to store lot of text files in oracle DB.I am working on RHEL c/c++ and oracle. I am thinking of using BLOB / BFILE . I have some questions
1. when i store the content in a BLOB those are not visible from ISQL however if I log into DB using putty and isql (command line interface to work with oracle DB) I am able to see the exact contents stored in table which means data is stored in as it is format. Initially i thought data would be in Binary format but it seems thats not the case
2.When I use BFILE and insert the data I see BFILE column scrambled. I am not able to understand exactly in what pattern its stored and to get the filename i have to use some PL/SQL function.
Is there any way I can understand how exactly data is stored in both types of columns .
Thanks in advance ...