Skip to main content
Oracle Help Center

Sign Out

Sign In

  • Table of Contents
  • Search
  • Print
  • Download
  1. Database
  2. Oracle
  3. Oracle Database
  4. Release 18

SQL Language Reference

  • Table of Contents
  • Search
  • Print
  • Download

Table of Contents

Loading...

Search

Print

Download

PDF for offline and print

  • Previous
  • Next
  1. SQL Language Reference
  2. Functions
  3. TO_BLOB (raw)

TO_BLOB (raw)

Syntax

to_blob::=

Description of to_blob.eps follows
Description of the illustration to_blob.eps

Purpose

TO_BLOB (raw) converts LONG RAW and RAW values to BLOB values.

From within a PL/SQL package, you can use TO_BLOB (raw) to convert RAW and BLOB values to BLOB.

Examples

The following hypothetical example returns the BLOB of a RAW column value:

SELECT TO_BLOB(raw_column) blob FROM raw_table;

BLOB
-----------------------
00AADD343CDBBD
  • Previous
  • Next
Back to main content
  • About Oracle
  • Contact Us
  • Legal Notices
  • Terms of Use
  • Your Privacy Rights
Copyright © 1996, 2018, Oracle and/or its affiliates. All rights reserved.
  • Previous
  • Next
Video