milindsj@gmail.com wrote:
> Thanks alot,
> But we dont have interMedia.
> Is there any other way to find out what is the type present in blob
> (jpg, xls, gif, png etc)??
>
> Milind

Why don't you think you have interMedia?

Q: Do I have to buy a separate option or license to do it?
No. Oracle10g includes a component called interMedia that makes it
possible to manage digital media. interMedia is a component of the
Oracle Database and is included in Oracle Database licensing.

Source:
http://www.oracle.com/technology/pro...media_faq.html
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)