Solved

How to store word file in oracle 10g

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

thanks
Sathish
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

696 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