I have entered video & picture data in ORACLE database . now i want to
retrive that data in some front end tool . how is it possible??
please help me...so as to help me in developing one application...

thanks

Hi ayan, 
You can use your movie/picture file as blob to store into Oracle. But
to store it into Oracle, first you'll have to convert your file into a
blob object and it will depend on the type of language you are
planning. You can use java to convert your file to blob object and
then you can insert in using a simple query into Oracle and similarly
you can retrieve it also.
 
This link speaks about exactly what you are looking for: 
&lt;a href=&quot;<a href="http://support.microsoft.com/default.aspx?scid=kb;EN-US;q185958">http://support.microsoft.com/default.aspx?scid=kb;EN-US;q185958</a>&quot;&gt;<a href="http://support.microsoft.com/default.aspx?scid=kb;EN-US;q185958">http://support.microsoft.com/default.aspx?scid=kb;EN-US;q185958</a>&lt;/a&gt; 
 
There is a thread on how to Display BLOB\'S stored in Oracle8. The
code I guess is in C.
&lt;a href=&quot;<a href="http://www.phpbuilder.com/forum/archives/5/2000/10/1/2621">http://www.phpbuilder.com/forum/archives/5/2000/10/1/2621</a>&quot;&gt;<a href="http://www.phpbuilder.com/forum/archives/5/2000/10/1/2621">http://www.phpbuilder.com/forum/archives/5/2000/10/1/2621</a>&lt;/a&gt; 
 
Here is a site which gives you the exact details and also the code for
how to store and retrieve the picture data from database. They have
taken Access as database but you can give a try with Oracle for the
same. They are using ActiveX control and XML to get this.
&lt;a href=&quot;<a href="http://www.eggheadcafe.com/articles/20010713.asp">http://www.eggheadcafe.com/articles/20010713.asp</a>&quot;&gt;<a href="http://www.eggheadcafe.com/articles/20010713.asp">http://www.eggheadcafe.com/articles/20010713.asp</a>&lt;/a&gt; 
 
This site also gives a sample code to &amp;quot;retrieve a bitmap from an
Oracle BLOB field using DAO&amp;quot;
&lt;a href=&quot;<a href="http://groups.google.com/groups?selm=8er0fr%24sal%241%40nnrp1.deja.com&amp;amp;output=gplain">http://groups.google.com/groups?selm=8er0fr%24sal%241%40nnrp1.deja.com&amp;amp;output=gplain</a>&quot;&gt;<a href="http://groups.google.com/groups?selm=8er0fr%24sal%241%40nnrp1.deja.com&amp;amp;output=gplain">http://groups.google.com/groups?selm=8er0fr%24sal%241%40nnrp1.deja.com&amp;amp;output=gplain</a>&lt;/a&gt;
 
I hope these examples will help you in getting the functionality you
are looking for.
 
Regards, 
netcrazy  

---

Clarification of Answer by netcrazy-ga on 19 May 2002 09:43 PDT

Hello ayan, 
I'm sorry that you didn't like the answer. But I've given the answer
as per your question only. You've not specified anywhere that you just
know Oracle and no other language. Anyway, you'll need some program
language to retrieve the data which you already have in your database.
This can be done using the Stored Procedures in Oracle but to call
these procedures also, you'll need some programming language. To help
you in this, "Pro C" is one of such languages which can help in
calling the store procedures. Also, you can use SQL Plus in Oracle to
retrieve your data. This is a graphical as well as Command line tool
to run queries with Oracle.
I've again checked net to find out more on this, but again it shows me
some fully functional code in some language.
Here is the exact code in PHP: 
<a href="http://www.faqts.com/knowledge_base/view.phtml/aid/2348/fid/15">http://www.faqts.com/knowledge_base/view.phtml/aid/2348/fid/15</a> 
 
There is a tool ColdFusion which will answer your requirement. 
<a href="http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=45&amp;lngWId=9">http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=45&amp;lngWId=9</a>
 
This is a Java code with full functionality for what you are looking
for.
<a href="http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/advanced/LOBSample/LOBSample.java.html">http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/advanced/LOBSample/LOBSample.java.html</a>
 
Check out this one too from SSJS. 
<a href="http://developer.netscape.com/docs/presentations/codestock/javascript/codesto2.html#BLObs">http://developer.netscape.com/docs/presentations/codestock/javascript/codesto2.html#BLObs</a>
 
I hope now you'll be able to get the tool and required code to
retrieve your files. I'm open to your suggestions and to your queries,
if any. I hope this will help you now in reconsidering my ratings.
 
Thanks 
netcrazy 

I have gone through all links you suggested , but i don't fine any
quick solution as i wrote in my question. You have suggested sites
that shows by UML,XML & C..which i don't no much !! I know ORACLE
only..!! No any link i found that can help me to know how to store &
retrive data from ORACLE database.
I appreciate your efforts & i'll be continue to be in touch with
you..but for current answer i'm not at all setisfied...So i request
refund of my money if possible....with thanks Ayan...........NOTE::I
like to say thanks for your kind efforts..

I have gone through all links you suggested , but i don't fine any
quick solution as i wrote in my question. You have suggested sites
that shows by UML,XML & C..which i don't no much !! I know ORACLE
only..!! No any link i found that can help me to know how to store &
retrive data from ORACLE database.
I appreciate your efforts & i'll be continue to be in touch with
you..but for current answer i'm not at all setisfied...So i request
refund of my money if possible....with thanks Ayan...........NOTE::I
like to say thanks for your kind efforts..

You may also find this New Architect article helful, as an overview
and explanation before you dive into the code given above.

"Oracle 8i, Java, and the Mustang Index" by Ken North. New Architect,
November 1999. (scroll to heading "Using Rich Data Types")
http://www.webtechniques.com/archives/1999/11/data/

Take a look at:
http://otn.oracle.com/products/intermedia/content.html

Also take a look at some sample code here:
http://otn.oracle.com/sample_code/products/intermedia/content.html

All the spectrum of items is covered here.

BTW, I am not an pproved person from Google to be able to anser your
question, so you can t take this is an answer!