This discussion is archived
1 Reply Latest reply: Oct 15, 2012 11:50 AM by rp0428 RSS

Data type to store exccel spread sheet result in Oracle database

557534 Newbie
Currently Being Moderated
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?

Thanks in advance
  • 1. Re: Data type to store exccel spread sheet result in Oracle database
    rp0428 Guru
    Currently Being Moderated
    >
    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
    http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements001.htm
    >
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points