I am working on a web application using JSP.
I want to ask which datatype(with syntax) is used to store video files in Oracle database.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
You probably shouldn't be storing the video in the database at all. Just store the metadata about it in the database and put the video itself on a filesystem, which is much more appropriate for storing such stuff.
More details in the two good answers at Images, PDF, audio and video files in MySQL - of which this question is arguably a duplicate.
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.
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.