Using CFILE and BFILE Data Types

The CFILE and BFILE data types work differently than their counterpart BLOB, CLOB, and NCLOB types. The largest differences are that they’re read-only LOB data types and stored externally from the database. CFILE columns typically store character files, like static HTML pages. BFILE data types typically reference binary files, like image, Portable Document Format (PDF), and compressed files.

This section will examine the process of storing, referencing, and accessing BFILE column values containing images of U.S. presidents taken from the White House web site at www.whitehouse.gov/history/presidents/. You will find Graphics Interchange Format (GIF) and Joint Photographic Experts Group (JPG) images for the first ...

Get Oracle Database 10g Express Edition PHP Web Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.