摘要:
@Entity @Table(name="TABLE_NAME") public class TableName implements Serializable { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE,generator="a 阅读全文
摘要:
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... 阅读全文
摘要:
grant all on *.* to databaseName@'ipAddress' identified by 'somePassword'; flush privileges; 阅读全文
摘要:
alter user wms_user ACCOUNT UNLOCK 阅读全文
摘要:
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 阅读全文
摘要:
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 ' || '' 阅读全文
摘要:
select wmsys.wm_concat(id) from table_name where id >= 5000 and id < 6000 阅读全文
摘要:
select * from v$resource_limit; 阅读全文
摘要:
dbms_output.put_line('code:' || sqlcode); dbms_output.put_line('errm:' || sqlerrm); dbms_output.put_line('lineno:' || dbms_utility.format_error_backtr 阅读全文
摘要:
mvn install:install-file -DgroupId=com.lowagie -DartifactId=itextasian -Dversion=1.0 -Dpackaging=jar -Dfile=iTextAsian.jar 阅读全文