`
文章列表
监控和剖析数据库操作 -- P6Spy、SQL Profiler、IronTrack SQL 使用简介: http://www.ibm.com/developerworks/cn/java/j-lo-p6spy/index.html P6Spy & SQL Profiler & IronTrack SQL: http://www.iteye.com/topic/28880 P6Spy P6Spy是一个可以用来在应用程序中拦截和修改数据操作语句的开源框架。 通过P6Spy我们可以对SQL语句进行拦截,相当于一个SQL语句的记录器,这样我们可以用它来作相关的分析,比如性能分析。 ...
使用struts2验证是报错: 引用Attribute "short-circuit" must be declared for element type "validator". 解决办法: 将<actionClass>-<actionAlias>-validation.xml的头: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE validators PUBLIC "-//Ope ...
Struts2 valiation: 分编程式验证、声明式验证、注解式验证。 声明式验证: http://struts.apache.org/2.x/docs/validation.html http://iehyou.iteye.com/blog/577214 http://hsw212.iteye.com/blog/300129 关于xxxAction-actionName-validation.xml:引用struts验证分为2种:Non-Field Validator 和 Field-Validator 引用There are two ways you can define val ...
Oracle多粒度封锁机制研究: http://www.itpub.net/viewthread.php?tid=202492&highlight=%CB%F8 我对ORACLE数据锁的一点体会: http://www.itpub.net/viewthread.php?tid=270059&highlight=%CB%F8 在Oracle中如何实现读锁: http://www.itpub.net/viewthread.php?tid=995175&highlight=%CB%F8 给表加锁: lock table tablename in modename m ...
Oracle数据字典查阅: http://download.oracle.com/docs/cd/B14117_01/server.101/b10755/toc.htm 关于数据字典中的视图 ALL_OBJECTS/DBA_OBJECTS/USER_OBJECTS的区别: http://download.oracle.com/docs/cd/B14117_01/server.101/b10755/statviews_1102.htm#sthref1293引用ALL_OBJECTS describes all objects accessible to the current user. DB ...
Oracle/PLSQL: Sign Function: http://www.techonthenet.com/oracle/functions/sign.php 引用 In Oracle/PLSQL, the sign function returns a value indicating the sign of a number. The syntax for the sign function is: sign( number ) number is the number to test for its sign. If number < 0, then sign retu ...
next_day(date,char): 它用来返回从第一个参数指定的日期开始,第一次到达第二个参数(星期)的日期. 返回日期晚于参数date,且星期为CHAR的那一天的日期。 参数date的取值与数据库的Locale有关,CHAR的取值为1~7或星期的中/英文(具体是中文还是英文,也取决于数据库的Locale) http://www.techonthenet.com/oracle/functions/next_day.php http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions093.htm ...
Oracle/PLSQL: Creating Procedures: http://www.techonthenet.com/oracle/procedures.php引用The syntax for a procedure is: CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,parameter]) ] IS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [p ...
Handling PL/SQL Errors: http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/07_errs.htm引用 Retrieving the Error Code and Error Message: SQLCODE and SQLERRM: In an exception handler, you can use the built-in functions SQLCODE and SQLERRM to find out which error occurred and to get the associ ...
Oracle: 三个内置的性能工具包 Explain plan、Autotrace、Tkprof: http://vitas08xy.blog.sohu.com/108168502.html Oracle EXPLAIN PLAN 执行计划 Using EXPLAIN PLAN: http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/ex_plan.htm#PFGRF009 通过分析SQL语句的执行计划优化SQL(总结): http://www.itpub.net/thread-478999-1-11.html#引用读笔 ...
toad执行一个查询,弹出的模态查询对话框会使什么都干不了了;如果查询的时间过长,很不方便,怎么办? 可以调整软件运行为多线程: 安装的时候有选项设置,如果未设置进入view-options-oracle-transactions,把第一个选项选上 关于View - Options - Oracle - Transactions - Execute Queries in Threads: http://old.nabble.com/Statement-Processing...-td14223992.html http://asktoad.com/DWiki/doku.php/faq/answ ...
关于Oracle数据和对象的导入导出 [转]: http://www.cnblogs.com/oapro/archive/2006/04/14/374908.html
ORA-08002 sequence string.CURRVAL is not yet defined in this session Cause sequence CURRVAL has been selected before sequence NEXTVAL Action select NEXTVAL from the sequence before selecting CURRVAL http://www.techonthenet.com/oracle/errors/ora08002.php
Extending array prototype with sum, minimum, maximum and remove http://snippets.dzone.com/posts/show/5753 Array.prototype.sum = function(){ for (var i=0, sum=0; i < this.length; sum += this[i++]); return sum; } Array.prototype.max = function(){ return Math.max.apply({},this) } Array.p ...
parentElement and children is for IE parentNode and childNodes is for all browsers you should use this one to make crossbrowser code http://blog.csdn.net/teresa502/archive/2009/12/08/4962282.aspx
Global site tag (gtag.js) - Google Analytics