Oracle APEX Best Practices by unknow

Author:unknow
Language: eng
Format: epub
Publisher: Packt Publishing

The UTL_RAW.CAST_TO_VARCHAR2 function converts a raw value into a value of datatype VARCHAR2 with the same number of data bytes. The result is treated as if it was composed of single "8-bit" bytes, not characters. Multibyte character boundaries are ignored. The data is not modified in any way—it is only changed to datatype VARCHAR2.

The UTL_ENCODE.BASE64_ENCODE function encodes the binary representation of the RAW value into base 64 elements and returns it in the form of a RAW string.

The DBMS_LOB.SUBSTR function selects the requested number of characters of a BLOB column from a given starting position.

Create a report query and layout to show the CLOB column:

select employee_id, first_name, last_name, blob2clobase64(photo) from employees where photo is not null

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.