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 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.
