Home
More icon
Categories Tags
Links icon
Apex Tutorials Web Development
About
  • Blob to Clob Using DBMS_LOB

    Posted by - Ashish Sahay Feb 29, 2020 DBMS_LOB PLSQL

    Create function to convert the blob content to clob 1CREATE OR REPLACE FUNCTION blob_to_clob (i_blob_content IN BLOB) 2 RETURN CLOB 3AS 4 l_chunk VARCHAR2 (32767); 5 l_position PLS_INTEGER := 1; 6 l_buffer_size PLS_INTEGER := 32767; 7 l_clob_text CLOB; 8BEGIN 9 -- Create temprary 10 DBMS_LOB.createtemporary …

    Read More
  • CLOB to BLOB using PLSQL

    Posted by - Ashish Sahay Feb 29, 2020 ORACLE PLSQL DBMS_LOB

    Create function to convert the CLOB to BLOB 1CREATE OR REPLACE FUNCTION clob_to_blob (i_clob_text IN CLOB) 2 RETURN BLOB 3IS 4 /* 5Version 1 29-mar-2020 6*/ 7 l_blob_file BLOB; 8 l_lob_length PLS_INTEGER := DBMS_LOB.getlength (i_clob_text); 9 l_position PLS_INTEGER := 1; 10 l_buffer_size RAW (32767); 11BEGIN 12 …

    Read More

Ontoor Soluions


APEX, PLSQL and Web development Blogs
Read More

Featured Posts

Recent Posts

  • Dynamic position Navigation Menu Oracle Apex
  • Add Tooltip on Side Navigation Menu Oracle APEX
  • Creating a custom template oracle apex part-1
  • Add Search Option On Nav Bar Oracle Apex
  • Refresh region of base page when closing modal dialog | Oracle APEX
  • Interactive Grid Checkbox
  • Mega Menu Oracle Apex
  • Table Blob to Oracle Directory

categories

APEX 97 ORACLE 24 PLSQL 13 DBA 5 GITHUB 4 BLOGGER 3 JAVASCRIPT 3 ORDS 3 APEX_JSON 2 CSS 1 PLSQLAPEX_WEB_SERVICE 1 PLUGIN 1 SCRUM 1 SQL 1

tags

PLSQL 104 APEX 101 SQL 93 ORACLE 32 PLUGINS 23 TEMPLATES 14 DYNAMIC-ACTION 9 ONTOORPLUGINS 9 JAVASCRIPT 7 CLASSIC-REPORT 5 DBA 5 UNIVERSAL-THEME 4 API 3 BLOGGER 3
All tags
AGILE1 APEX101 APEX+CSS2 APEX-20.11 APEX-AND-CSS1 APEX.SERVER2 APEX_DATA_PARSER1 APEX_DATA_PASER2 APEX_JSON2 APEX_UTIL1 APEX_WEB_SERVICE2 APEX_ZIP1 API3 BLOB1 BLOGGER3 CASCADE1 CLASSIC-REPORT5 CLOB1 COALESCE2 CSS3 CUSTOM1 DBA5 DBMS_LOB2 DELETED1 DIRECTORY1 DOWNLOAD1 DYNAMIC-ACTION9 FUNCTION1 GITHUB3 GOOGLE2 HTML1 IG1 INDEX1 INTERACTIVE-ACTIVE1 INTERACTIVE-GRID2 INTERACTIVE-REPORT2 IR1 ITEM2 JAVASCRIPT7 JQUERY1 LOV1 MARKDOWN2 MEGA-MENU1 NAVIGATION1 NEW-LINE1 NULL1 NULLIF1 NVL1 NVL21 ONTOORPLUGINS9 ORA1 ORACLE32 ORACLE_TO_XML1 ORDS3 PAGE1 PAGE-GROUP1 PAGE-ZERO1 PIPELINE1 PLSQL104 PLUGINS23 POP-UP-LOV1 RDS2 REPLACE1 RSS1 SCRUM1 SELECT-LIST1 SPECIAL-CHARACTER1 SQL93 STICKY1 SUBSCRIPTIONS1 SYS_CONTEXT1 TABULAR-FORM1 TEMPLATE2 TEMPLATES14 UI3 UNIVERSAL-THEME4 USER-STORIES1 UTL_FILE1 WEB_SOURCE1
[A~Z][0~9]

Tweets by OntoorSolutions

Copyright ©   Ontoor Solutions Blogs. All Rights Reserved