lanxulin的博客

引言： drop table books;的指令会将表放到回收站里，  用  flashback table "BIN$1Oiy3qm/QJubov1BwBUOgw==$0" to before drop;  就能恢复。  删除表：  drop table books purge;是绕过回收站，彻底删除  建议你先  purge recyclebin;  清除当前用户的回

1.jdbc读取blob字段 FileUtils fu = new FileUtils(); String []array = fu.toByteArray(rs.getBlob("PICTURE"))； Blob blob = rs.getBlob("PICTURE"); 2.更新blob OracleResultSet oracleResultSet  = (OracleRe

public boolean xx(String xx) { Connection conn = null; Statement stmt = null; CallableStatement   proc   =   null;  List sqlList = new ArrayList(); try { Session session = HibernateSessionFactor

create or replace procedure update is cursor c1 is select s.id as column1,t.huzhu_name as column2  from table1 s,table2 t  where t.id=s.apply_id ; begin for r1 in c1 loop update table1 a set a.h