This content has been marked as final. Show 1 reply
I have a requirement where we have to upload excel spreadsheet from java application to oracle database.
Can anyone suggest what will be the suitable datatype to store excel spreadsheet in oracle database?
BLOB would be the proper datatype. It can store large amounts of unstructured (as far as Oracle knows) binary data.
See the Datatypes section of the SQL Language doc
Large Object (LOB) Datatypes
The built-in LOB datatypes BLOB, CLOB, and NCLOB (stored internally) and BFILE (stored externally) can store large and unstructured data such as text, image, video, and spatial data. The size of BLOB, CLOB, and NCLOB data can be up to (232-1 bytes) * (the value of the CHUNK parameter of LOB storage). If the tablespaces in your database are of standard block size, and if you have used the default value of the CHUNK parameter of LOB storage when creating a LOB column, then this is equivalent to (232-1 bytes) * (database block size). BFILE data can be up to 264-1 bytes, although your operating system may impose restrictions on this maximum.
When creating a table, you can optionally specify different tablespace and storage characteristics for LOB columns or LOB object attributes from those specified for the table.
CLOB, NCLOB, and BLOB values up to approximately 4000 bytes are stored inline if you enable storage in row at the time the LOB column is created. LOBs greater than 4000 bytes are always stored externally. Refer to ENABLE STORAGE IN ROW for more information.