CHAPTER
10
Large Objects
Large objects (LOBs) are powerful data structures that let you store text, images, music, and video in the database. Oracle Database 11g dramatically changed the LOB landscape by reengineering how large objects work. Oracle Database 12c builds upon those changes by optimizing the engines that support LOBs. They’re now faster and more secure (SecureFiles). You can now define Binary LOB (
BLOB), Character LOB (CLOB), or National Character LOB (NCLOB) columns in SecureFiles when you create a table or alter it.LOBs can hold up to a maximum of 8 to 128 terabytes, depending on how you configure your database’s
db_block_size ...Get Oracle Database 12c PL/SQL Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
