Hi..
Can we store whole file in database? ie it should store in database in same format. .pdf should store in .pdf fomat and .doc should store in .doc fomat.
That can be achieved using datatypes BLOB,CLOB,NCLOB,BFILE.
The dataypes BLOB is used to store the binary versions
The datatype CLOB is used to store the file in characters (ASCII)
NCLOB is similar to CLOB but it supports National Character set
BFILE - This dataype actually stores the Location pointer to the file which is stored externally in the hard disk.
Check out for more
here