empty_clob()方法怎么用 http://gigabase.idi.ntnu.no/oradoc/server.901/a90125/functions38.htm#77386UPDATE print_media SET ad_photo = EMPTY_BLOB(); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public static void clobRead(String outfile) throws Exception{/* 设定不自动提交 */boolean defaultCommit = conn.getAutoCommit();conn.setAutoCommit(false);try {/* 查询CLOB对象 */ResultSet rs = stmt.executeQuery("SELECT * FROM TEST_CLOB WHERE ID='111'");while (rs.next()) {/* 获取CLOB对象 */oracle.sql.CLOB clob = (oracle.sql.CLOB)rs.getClob("CLOBCOL");/* 以字符形式输出 */BufferedReader in = new BufferedReader(clob.getCharacterStream());BufferedWriter out = new BufferedWriter(new FileWriter(outfile));int c;while ((c=in.read())!=-1) {out.write(c);}out.close();in.close();}} catch (Exception ex) {conn.rollback();throw ex;}/* 恢复原提交状态 */conn.setAutoCommit(defaultCommit);} 求某张表中某字段每天的最大值,急,在线等 想把字段为空的纪录放在最前面 不懂的出错?菜鸟 oracle控制台登录报错 新建Orcal数据表问题 求救!怎样建立多表的Oracle视图! oracle PL/SQL 的 char 判断 请问ORACLE 9i可以在WIN200Pro下安装吗? 高分送上,关于在oracle中不能写中文记录的问题 ORACLE 求教??? blob 存数据出错,望高手指点~ 关于存储过程的问题!
try {/* 查询CLOB对象 */ResultSet rs = stmt.executeQuery("SELECT * FROM TEST_CLOB WHERE ID='111'");while (rs.next()) {/* 获取CLOB对象 */oracle.sql.CLOB clob = (oracle.sql.CLOB)rs.getClob("CLOBCOL");/* 以字符形式输出 */BufferedReader in = new BufferedReader(clob.getCharacterStream());BufferedWriter out = new BufferedWriter(new FileWriter(outfile));int c;while ((c=in.read())!=-1) {out.write(c);}out.close();in.close();}} catch (Exception ex) {conn.rollback();throw ex;}
/* 恢复原提交状态 */conn.setAutoCommit(defaultCommit);}