Shulou(Shulou.com)05/31 Report--

This article focuses on "how to convert Oracle blob type data into base64 encoding". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to convert Oracle blob type data into base64 encoding".

The demand goes something like this.

The Json format string of the base64 encoding list, and the image file format is jpg, such as:

"[{" employ_files ":" / 9j/4AAQSkZJRgABAQEAYABgAAD "}, {" employ_files ":" / 9j/4AAQSkZJRgABAQEAYABgAAD "}]"

Where employ_files is a required subentry

CREATE OR REPLACE FUNCTION base64encode (p_blob IN BLOB) RETURN CLOB---File Name: https://oracle-base.com/dba/ Miscellaneous/base64encode.sql-- Author: Tim Hall-- Description: Encodes a BLOB into a Base64 CLOB.-- Last Modified: 09 Universe 2011 Meri-IS l_clob CLOB L_step PLS_INTEGER: = 12000;-- make sure you set a multiple of 3 not higher than 24573BEGIN FOR i IN 0. TRUNC ((DBMS_LOB.getlength (p_blob)-1) / l_step) LOOP l_clob: = l_clob | | UTL_RAW.cast_to_varchar2 (DBMS_LOB.substr (DBMS_LOB.substr (p_blob, l_step, I * l_step + 1); END LOOP; RETURN lumped clobscape endpoint / at this point, I believe you have a better understanding of "how to convert Oracle blob type data into base64 encoding". You might as well do it in practice! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.