Tag: updating clob

• updating xml stored in oracle tables

  May 31, 2012

  Programming

  REM ********************************************************************** REM Set Environment parameters REM ********************************************************************** SET scan off; set serveroutput on size 100000; select ‘START TIME: ‘||to_char(sysdate,’mm/dd/yyyy hh24:mi:ss’) from dual; DECLARE xml_text1 clob; xml_text2 clob; xml_text3 clob; xml_text4 clob; xml_column_name VARCHAR2(50) := ‘demo.xml’; sql_stmt1 VARCHAR2(2000); sql_stmt2 VARCHAR2(2000); sql_stmt3 VARCHAR2(2000); sql_stmt4 VARCHAR2(2000); BEGIN xml_text1 :=’ –….. put your xml data here… ‘; xml_text2… Read.