Which datatype is used to store video files
Oracle Multimedia (formerly known as Oracle interMedia) lets you write applications to manage images, audio,video, and other heterogeneous media data in Oracle databases.


I have referenced interMedia as you are using Oracle 10g.

interMedia User's Guide

Here is a nice answer given by Justin Cave, which explains why would a person store a video file in a BLOB in a database and what are the advantages and disadvantages compared to storing pointers to the location of the video file.

BLOB's in SQL that stores a Video file