Hi
From the Front-end application ( Java ) we have an Browse button , where we can upload PDF,Word and Excel documents . The application is accessible to nearly 40 users and they can upload the documents from their machines .
(I studied that in oracle we have an option to store the documents .in the table itself using BLOB and BFILE )
Below are my questions
1)Which is the best option in oracle.
2)From the performance and security perspective, Is it good option to store the files in the database ?
3)If stored in database can we access ( view content ) the files from the database directly ( My requirement is to only display the content from front-end either through Save or download options )
Please provide any reference links if possible .
Thanks in advance