Syntax

to_blob_bfile::=

Purpose

TO_BLOB (bfile) converts a BFILE value to a BLOB value.

For mime_type, specify the MIME type to be set on the BLOB value returned by this function. If you omit mime_type, then a MIME type will not be set on the BLOB value.

Example

The following hypothetical example returns the BLOB of a BFILE column value media_col in table media_tab. It sets the MIME type to JPEG on the resulting BLOB.

SELECT TO_BLOB(media_col, 'JPEG') FROM media_tab;