动态批量初始化CLOB字段

ALTER TABLE SRVMONITOR_NODE ADD(RES_VIEW_CONF CLOB default '<?xml version="1.0" encoding="GBK"?>' NOT NULL);

 

declare
longliteral clob:='<?xml version="1.0" encoding="GBK"?>
<res_type_ids>
 <res_type_id name="WINDOWS" view="true">
  <comperf_type name="WINDOW_RSP_TIM" view="true"/>
  <comperf_type name="WINDOW_BURTHEN" view="true"/>
  <comperf_type name="WINDOW_DISK_USE_RATE" view="true"/>
  <comperf_type name="WINDOW_PROCESS_USE" view="true"/>
  <comperf_type name="WINDOW_NEWCARD_FLUX" view="true"/>
  <comperf_type name="WINDOW_FILE_BURTHEN" view="true"/>
  <comperf_type name="WINDOW_DEV_IO_BURTHEN" view="true"/>
 </res_type_id>
 <res_type_id name="LINUX" view="true">
  <comperf_type name="LINUX_RSP_TIM" view="true"/>
  <comperf_type name="LINUX_BURTHEN" view="true"/>
  <comperf_type name="LINUX_DISK_USE_RATE" view="true"/>
  <comperf_type name="LINUX_PROCESS_USE" view="true"/>
  <comperf_type name="LINUX_NEWCARD_FLUX" view="true"/>
  <comperf_type name="LINUX_DEV_IO_BURTHEN" view="true"/>
 </res_type_id>
 <res_type_id name="SOLARIS" view="true">
  <comperf_type name="SOLARIS_RSP_TIM" view="true"/>
  <comperf_type name="SOLARIS_BURTHEN" view="true"/>
  <comperf_type name="SOLARIS_DISK_USE_RATE" view="true"/>
  <comperf_type name="SOLARIS_PROCESS_USE" view="true"/>
  <comperf_type name="SOLARIS_NEWCARD_FLUX" view="true"/>
 </res_type_id>
 <res_type_id name="AIX" view="true">
  <comperf_type name="AIX_RSP_TIM" view="true"/>
  <comperf_type name="AIX_BURTHEN" view="true"/>
  <comperf_type name="AIX_DISK_USE_RATE" view="true"/>
  <comperf_type name="AIX_PROCESS_USE" view="true"/>
  <comperf_type name="AIX_NEWCARD_FLUX" view="true"/>
  <comperf_type name="AIX_DEV_IO_BURTHEN" view="true"/>
  <comperf_type name="AIX_NETSTAT_FLUX" view="true"/>
  <comperf_type name="AIX_FILE_BURTHEN" view="true"/>
 </res_type_id>
 <res_type_id name="CISCO" view="true">
  <comperf_type name="CISCO_RSP_TIM" view="true"/>
  <comperf_type name="CISCO_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="CISCO_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="CISCO_INTERFACE_FLUX" view="true"/>
  <comperf_type name="CISCO_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="AVAYA" view="true">
  <comperf_type name="AVAYA_RSP_TIM" view="true"/>
  <comperf_type name="AVAYA_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="AVAYA_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="AVAYA_INTERFACE_FLUX" view="true"/>
  <comperf_type name="AVAYA_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="SEC-STANDARD" view="true">
  <comperf_type name="SEC-STANDARD_RSP_TIM" view="true"/>
  <comperf_type name="SEC-STANDARD_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="SEC-STANDARD_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="SEC-STANDARD_INTERFACE_FLUX" view="true"/>
  <comperf_type name="SEC-STANDARD_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="NETSCREEN" view="true">
  <comperf_type name="NETSCREEN_RSP_TIM" view="true"/>
  <comperf_type name="NETSCREEN_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="NETSCREEN_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="NETSCREEN_INTERFACE_FLUX" view="true"/>
  <comperf_type name="NETSCREEN_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="CHECKPOINT" view="true">
  <comperf_type name="CHECKPOINT_RSP_TIM" view="true"/>
  <comperf_type name="CHECKPOINT_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="CHECKPOINT_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="CHECKPOINT_INTERFACE_FLUX" view="true"/>
  <comperf_type name="CHECKPOINT_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="TOMCAT" view="true">
  <comperf_type name="TOMCAT_RSP_TIM" view="true"/>
  <comperf_type name="TOMCAT_JVM" view="true"/>
 </res_type_id>
 <res_type_id name="APACHE" view="true">
  <comperf_type name="APACHE_RSP_TIM" view="true"/>
  <comperf_type name="APACHE_REQUEST_LOAD" view="true"/>
  <comperf_type name="APACHE_DEAL_LOAD" view="true"/>
  <comperf_type name="APACHE_TASK_LOAD" view="true"/>
  <comperf_type name="APACHE_CPU_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="MS-STANDARD" view="true">
  <comperf_type name="MS-STANDARD_RSP_TIM" view="true"/>
 </res_type_id>
 <res_type_id name="RESIN" view="true">
  <comperf_type name="RESIN_CPU_BURTHEN" view="true"/>
  <comperf_type name="RESIN_POOL_BURTHEN" view="true"/>
  <comperf_type name="RESIN_RATIO_BURTHEN" view="true"/>
  <comperf_type name="RESIN_WEBAPP_BURTHEN" view="true"/>
 </res_type_id>
 <res_type_id name="NORTEL" view="true">
  <comperf_type name="NORTEL_RSP_TIM" view="true"/>
  <comperf_type name="NORTEL_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="NORTEL_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="NORTEL_INTERFACE_FLUX" view="true"/>
  <comperf_type name="NORTEL_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="WEBLOGIC" view="true">
  <comperf_type name="WEBLOGIC_RSP_TIM" view="true"/>
  <comperf_type name="WEBLOGIC_JVM" view="true"/>
  <comperf_type name="WEBLOGIC_JDBC" view="true"/>
  <comperf_type name="WEBLOGIC_JTA" view="true"/>
  <comperf_type name="WEBLOGIC_WEB" view="true"/>
  <comperf_type name="WEBLOGIC_THREAD" view="true"/>
  <comperf_type name="WEBLOGIC_SERVLET" view="true"/>
  <comperf_type name="WEBLOGIC_EJB" view="true"/>
 </res_type_id>
 <res_type_id name="SNMP" view="true">
  <comperf_type name="SNMP_COMPERF" view="true"/>
 </res_type_id>
 <res_type_id name="IIS" view="true">
  <comperf_type name="IIS_BASEINFO" view="true"/>
  <comperf_type name="IIS_CONN_BURTHEN" view="true"/>
  <comperf_type name="IIS_TRANSFERBYTES_BURTHEN" view="true"/>
  <comperf_type name="IIS_TRANSFERFILES_BURTHEN" view="true"/>
  <comperf_type name="IIS_USERS_BURTHEN" view="true"/>
  <comperf_type name="IIS_REQUEST_BURTHEN" view="true"/>
 </res_type_id>
 <res_type_id name="HUAWEI" view="true">
  <comperf_type name="HUAWEI_RSP_TIM" view="true"/>
  <comperf_type name="HUAWEI_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="HUAWEI_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="HUAWEI_INTERFACE_FLUX" view="true"/>
  <comperf_type name="HUAWEI_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="HP-UX" view="true">
  <comperf_type name="HPUX_RSP_TIM" view="true"/>
  <comperf_type name="HPUX_BURTHEN" view="true"/>
  <comperf_type name="HPUX_DISK_USE_RATE" view="true"/>
  <comperf_type name="HPUX_PROCESS_USE" view="true"/>
  <comperf_type name="HPUX_NEWCARD_FLUX" view="true"/>
 </res_type_id>
 <res_type_id name="MYSQL" view="true">
  <comperf_type name="MYSQL_RSP_TIM" view="true"/>
  <comperf_type name="MYSQL_DBLOAD" view="true"/>
  <comperf_type name="MYSQL_DB_USE" view="true"/>
 </res_type_id>
 <res_type_id name="JMS" view="true">
  <comperf_type name="JMS_RSP_TIM" view="true"/>
  <comperf_type name="JMS_COMPERF" view="true"/>
 </res_type_id>
 <res_type_id name="LDAP" view="true">
  <comperf_type name="LDAP_RSP_TIM" view="true"/>
 </res_type_id>
 <res_type_id name="TCP" view="true">
  <comperf_type name="TCP_RSP_TIM" view="true"/>
 </res_type_id>
 <res_type_id name="NW-STANDARD" view="true">
  <comperf_type name="STANDARD_RSP_TIM" view="true"/>
  <comperf_type name="STANDARD_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="STANDARD_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="STANDARD_INTERFACE_FLUX" view="true"/>
  <comperf_type name="STANDARD_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="HARBOUR" view="true">
  <comperf_type name="HARBOUR_RSP_TIM" view="true"/>
  <comperf_type name="HARBOUR_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="HARBOUR_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="HARBOUR_INTERFACE_FLUX" view="true"/>
  <comperf_type name="HARBOUR_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="Sybase" view="true">
  <comperf_type name="SYBASE_RSP_TIM" view="true"/>
  <comperf_type name="SYBASE_COMPERF" view="true"/>
 </res_type_id>
 <res_type_id name="WEBSPHERE" view="true">
  <comperf_type name="WEBSPHERE_RSP_TIM" view="true"/>
  <comperf_type name="WEBSPHERE_JDBC" view="true"/>
  <comperf_type name="WEBSPHERE_JVM" view="true"/>
  <comperf_type name="WEBSPHERE_WEB" view="true"/>
  <comperf_type name="WEBSPHERE_THREADPOOL" view="true"/>
  <comperf_type name="WEBSPHERE_SERVLET" view="true"/>
  <comperf_type name="WEBSPHERE_TRANS" view="true"/>
  <comperf_type name="WEBSPHERE_J2C" view="true"/>
  <comperf_type name="WEBSPHERE_EJB" view="true"/>
  <comperf_type name="WEBSPHERE_CACHE" view="true"/>
 </res_type_id>
 <res_type_id name="IBMMQ" view="true">
  <comperf_type name="IBMMQ_RSP_TIM" view="true"/>
  <comperf_type name="IBMMQ_COMPERF" view="true"/>
 </res_type_id>
 <res_type_id name="HTTP" view="true">
  <comperf_type name="HTTP_COMPERF_RSP_TIM" view="true"/>
 </res_type_id>
 <res_type_id name="MSSQL" view="true">
  <comperf_type name="MSSQL_DBLOAD" view="true"/>
  <comperf_type name="MSSQL_DBFILE_USE" view="true"/>
  <comperf_type name="MSSQL_DBSIZE" view="true"/>
  <comperf_type name="MSSQL_FILE" view="true"/>
 </res_type_id>
 <res_type_id name="SYBASE" view="true">
  <comperf_type name="SYBASE_DB_LOAD" view="true"/>
  <comperf_type name="SYBASE_SEGMENT" view="true"/>
 </res_type_id>
 <res_type_id name="DNS" view="true">
  <comperf_type name="DNS_RSP_TIM" view="true"/>
 </res_type_id>
 <res_type_id name="FTP" view="true">
  <comperf_type name="FTP_RSP_TIM" view="true"/>
 </res_type_id>
 <res_type_id name="CISCO-PIX" view="true">
  <comperf_type name="CISCO-PIX_RSP_TIM" view="true"/>
  <comperf_type name="CISCO-PIX_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="CISCO-PIX_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="CISCO-PIX_INTERFACE_FLUX" view="true"/>
  <comperf_type name="CISCO-PIX_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="DB2" view="true">
  <comperf_type name="DB2_DBLOAD" view="true"/>
  <comperf_type name="DB2_TABLESPACE" view="true"/>
  <comperf_type name="DB2_TABLESPACE_CONT" view="true"/>
  <comperf_type name="DB2_BUFFERPOLL" view="true"/>
  <comperf_type name="DB2_LOCK" view="true"/>
  <comperf_type name="DB2_SORT" view="true"/>
 </res_type_id>
 <res_type_id name="FREEBSD" view="true">
  <comperf_type name="FREEBSD_RSP_TIM" view="true"/>
  <comperf_type name="FREEBSD_BURTHEN" view="true"/>
  <comperf_type name="FREEBSD_DISK_USE_RATE" view="true"/>
  <comperf_type name="FREEBSD_PROCESS_USE" view="true"/>
  <comperf_type name="FREEBSD_NEWCARD_FLUX" view="true"/>
 </res_type_id>
 <res_type_id name="FOUNDRY" view="true">
  <comperf_type name="FOUNDRY_RSP_TIM" view="true"/>
  <comperf_type name="FOUNDRY_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="FOUNDRY_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="FOUNDRY_INTERFACE_FLUX" view="true"/>
  <comperf_type name="FOUNDRY_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="ORACLE" view="true">
  <comperf_type name="ORACLE_RSP_TIM" view="true"/>
  <comperf_type name="ORACLE_SGA" view="true"/>
  <comperf_type name="ORACLE_ROLL" view="true"/>
  <comperf_type name="ORACLE_DATAFILE" view="true"/>
  <comperf_type name="ORACLE_RATIO" view="true"/>
  <comperf_type name="ORACLE_TABLESPACE" view="true"/>
 </res_type_id>
 <res_type_id name="DOMINO" view="true">
  <comperf_type name="DOMINO_RSP_TIM" view="true"/>
  <comperf_type name="DOMINO_BASIC" view="true"/>
  <comperf_type name="DOMINO_SRV_LOAD" view="true"/>
  <comperf_type name="DOMINO_COPY" view="true"/>
  <comperf_type name="DOMINO_EMAIL" view="true"/>
  <comperf_type name="DOMINO_BUFF" view="true"/>
 </res_type_id>
 <res_type_id name="HTTPS" view="true">
  <comperf_type name="HTTPS_RSP_TIM" view="true"/>
 </res_type_id>
 <res_type_id name="DLINK" view="true">
  <comperf_type name="DLINK_RSP_TIM" view="true"/>
  <comperf_type name="DLINK_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="DLINK_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="DLINK_INTERFACE_FLUX" view="true"/>
  <comperf_type name="DLINK_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="INFORMIX" view="true">
  <comperf_type name="INFORMIX_DBLOAD" view="true"/>
  <comperf_type name="INFORMIX_IO_RATE" view="true"/>
  <comperf_type name="INFORMIX_DATASPACE_RATE" view="true"/>
  <comperf_type name="INFORMIX_SHM" view="true"/>
  <comperf_type name="INFORMIX_CHKPT" view="true"/>
  <comperf_type name="INFORMIX_TRANS" view="true"/>
  <comperf_type name="INFORMIX_LOCK" view="true"/>
  <comperf_type name="INFORMIX_DISK" view="true"/>
  <comperf_type name="INFORMIX_LOG" view="true"/>
  <comperf_type name="INFORMIX_SORT" view="true"/>
 </res_type_id>
 <res_type_id name="REDGIANT" view="true">
  <comperf_type name="REDGIANT_RSP_TIM" view="true"/>
  <comperf_type name="REDGIANT_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="REDGIANT_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="REDGIANT_INTERFACE_FLUX" view="true"/>
  <comperf_type name="REDGIANT_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="TOPSEC" view="true">
  <comperf_type name="TOPSEC_RSP_TIM" view="true"/>
  <comperf_type name="TOPSEC_DEVICE_BURTHEN_CPU" view="true"/>
  <comperf_type name="TOPSEC_DEVICE_BURTHEN_RAM" view="true"/>
  <comperf_type name="TOPSEC_INTERFACE_FLUX" view="true"/>
  <comperf_type name="TOPSEC_INTERFACE_DOWN_RATE" view="true"/>
 </res_type_id>
 <res_type_id name="TONGWEB" view="true">
  <comperf_type name="TONGWEB_RSP_TIM" view="true"/>
  <comperf_type name="TONGWEB_CONN_INFO" view="true"/>
  <comperf_type name="TONGWEB_CONN_POOL" view="true"/>
 </res_type_id>
 <res_type_id name="TUXEDO" view="true">
  <comperf_type name="TUXEDO_RSP_TIM" view="true"/>
  <comperf_type name="TUXEDO_COMPERF" view="true"/>
 </res_type_id>
</res_type_ids>';
loblong binary_integer:=length(longliteral);
type lobloc_type is table of srvmonitor_node.res_view_conf%type;
lobloc lobloc_type;
begin
execute immediate 'select res_view_conf from srvmonitor_node for update' bulk collect into lobloc;
for i in lobloc.first..lobloc.last
loop
dbms_lob.write(lobloc(i), loblong, 1, longliteral);
end loop;
end;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值