Solved

How to store word file in oracle 10g

Posted on 2009-07-05
2
592 Views
Last Modified: 2013-12-19
Hi
How to store word file in oracle 10g  and retrive the file .

thanks
Sathish
0
Comment
2 Comments
 
LVL 13

Accepted Solution

by:
Murali Murugesan earned 250 total points
ID: 24783145
see this,

http://www.experts-exchange.com/Programming/Languages/Java/Q_24455650.html

you need to store as BLOB field in db tables and retrieve them appropriately.

-Murali*
0
 
LVL 20

Assisted Solution

by:gatorvip
gatorvip earned 250 total points
ID: 24785057
If you have a lot of files to upload, the best approach is arguably  to store the files on disk (in a virtual/physical server environment) and then store the path to the files in the database.

However if you want to store the files themselves in the database, then use a BLOB field. How you upload depends on the technology used. MuraliKanth's post above deals with uploading from a JSP, but there are other alternatives:
ADO: http://narfle.com/ref/asp/oracleBlob.asp
VB6: http://stackoverflow.com/questions/848217/how-can-i-upload-a-file-to-an-oracle-blob-field-using-vb6

Oracle SQL Loader: http://www.experts-exchange.com/Database/Oracle/Q_24436520.html

and there are many more
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now