Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Storing Lob Data - One Blob Column vs Blob Column + Clob Column

littlecatMay 8 2024

Advice required.

I have report table which will store both text clob and binary blob data. There is column indicating whether data is blob or clob.

Which would you choose of below and why?

  1. One blob column where store blob directly and return blob to caller. For clobs convert to blob before store and convert blob back to clob to return to caller.
  2. One blob column for blob data and one clob column for clob data. No conversions required.

Was originally leaning to option 1, but rethinking as when store and return lob, need to know what kind of data are dealing with anyway, so modules required for each. The conversion process (dbms_lob.converttoblob/dbms_lob.converttoclob (aware APEX 23 has equivalent modules, but do not have yet)) works well, so that is not big issue.

Comments
Post Details
Added on May 8 2024
2 comments
344 views