摘要: select * from LITERSCORELOG as of timestamp to_timestamp('2018-05-15 01:10:00','YYYY-MM-DD HH24:MI:SS'); 简单明了 阅读全文
posted @ 2018-05-15 01:53 sysogg 阅读(133) 评论(0) 推荐(0) 编辑
摘要: create or replace procedure test1 (aid in varchar) isicount number; beginDBMS_OUTPUT.PUT_LINE('开始 AID:'|| aid);for wf in(SELECT * FROM SCORELOG WHERE 阅读全文
posted @ 2018-05-15 01:11 sysogg 阅读(115) 评论(0) 推荐(0) 编辑
摘要: public void runCountProc() { Object o = Db.execute(new ICallback() { @Override public Object call(Connection conn) throws SQLException { CallableState 阅读全文
posted @ 2018-05-15 00:42 sysogg 阅读(229) 评论(0) 推荐(0) 编辑