Handling Large Objects in the Database : Introduction « Large Objects « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Large Objects
  3. Introduction

To address performance concerns, Oracle provides two options:

You can store the large objects internally, within the database itself (CLOB, BLOB).

You can keep the objects in the file system and just store the filenames in the database (BFILE).

CLOB (character large object): to store large amounts of character (text) information.

BLOB (binary large object): to store binary (mostly video/audio) information in the database.

34.1.Introduction
34.1.1.Handling Large Objects in the Database
34.1.2.Large Objects
34.1.3.Using CLOBs and BLOBs