white knight

导航

 
上一页 1 ··· 8 9 10 11 12 13 14 15 16 下一页

2018年3月26日

摘要: @Entity @Table(name="TABLE_NAME") public class TableName implements Serializable { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE,generator="a 阅读全文
posted @ 2018-03-26 11:13 white knight 阅读(135) 评论(0) 推荐(0) 编辑
 
摘要: CREATE OR REPLACE PROCEDURE "PROCUDURE_NAME" (task_id NUMBER, deal_result out NUMBER, result_info out VARCHAR) AS BEGIN update TABLE_NAME set zzz ='z1' where ID = task_id; deal_result := 0; res... 阅读全文
posted @ 2018-03-26 11:11 white knight 阅读(138) 评论(0) 推荐(0) 编辑
 
摘要: grant all on *.* to databaseName@'ipAddress' identified by 'somePassword'; flush privileges; 阅读全文
posted @ 2018-03-26 11:09 white knight 阅读(96) 评论(0) 推荐(0) 编辑
 
摘要: alter user wms_user ACCOUNT UNLOCK 阅读全文
posted @ 2018-03-26 11:08 white knight 阅读(86) 评论(0) 推荐(0) 编辑
 
摘要: select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time; alter system kill se 阅读全文
posted @ 2018-03-26 11:07 white knight 阅读(142) 评论(0) 推荐(0) 编辑
 
摘要: select * from v$db_object_cache where locks > 0 and pins > 0 and type='PROCEDURE'; select b.sid,b.SERIAL#,a.OBJECT, 'alter system kill session ' || '' 阅读全文
posted @ 2018-03-26 11:06 white knight 阅读(3016) 评论(0) 推荐(0) 编辑
 
摘要: select wmsys.wm_concat(id) from table_name where id >= 5000 and id < 6000 阅读全文
posted @ 2018-03-26 11:05 white knight 阅读(510) 评论(0) 推荐(0) 编辑
 
摘要: select * from v$resource_limit; 阅读全文
posted @ 2018-03-26 11:05 white knight 阅读(248) 评论(0) 推荐(0) 编辑
 
摘要: dbms_output.put_line('code:' || sqlcode); dbms_output.put_line('errm:' || sqlerrm); dbms_output.put_line('lineno:' || dbms_utility.format_error_backtr 阅读全文
posted @ 2018-03-26 11:04 white knight 阅读(367) 评论(0) 推荐(0) 编辑
 
摘要: mvn install:install-file -DgroupId=com.lowagie -DartifactId=itextasian -Dversion=1.0 -Dpackaging=jar -Dfile=iTextAsian.jar 阅读全文
posted @ 2018-03-26 11:02 white knight 阅读(164) 评论(0) 推荐(0) 编辑
 
上一页 1 ··· 8 9 10 11 12 13 14 15 16 下一页