`
文章列表
web.xml   <?xml version="1.0" encoding="UTF-8"?><web-app version="2.4"  xmlns="http://java.sun.com/xml/ns/j2ee"  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee  http://java.su ...
var aElement=document.createElement("input");                       aElement.setAttribute("id","the_fee_str");                    aElement.id="the_fee_str";                    aElement.type="hidden";                     aElement.size="30";  ...

oracle01034与27101

http://dev.csdn.net/article/20/20163.shtm

随笔Hello world

某程序员对书法十分感兴趣,退休后决定在这方面有所建树。 于是花重金购买了上等的文房四宝。 一日,饭后突生雅兴,一番磨墨拟纸, 并点上了上好的檀香,颇有王羲之风范, 又具颜真卿气势,定神片刻,泼墨挥毫, 郑重地写下一行字:hello world.
ORA-01403: 未找到数据

oracle随笔

IF vn_count = 0 THEN  NULL;
set serveroutput onDECLARE TYPE assoc_array IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(30); state_array assoc_array;BEGIN  state_array('Alaska') := 'Juneau';  state_array('California') := 'Sacramento';  state_array('Oregon') := 'Salem';  state_array('Washington') := 'Olympia';  dbms_output.put_line(s ...

select类型

    博客分类:
  • JS
select-one
vs_sql := 'select object_value from '|| vs_table      ||' where city_code = :is_citycode'      ||' and service_kind = :in_service_kind'      ||' and object_id = :in_id'      ||' and object_control = 1';   begin    execute immediate vs_sql into on_value using is_citycode,in_service_kind,in_id;
只要下载apache-tomcat-5.5.12-compat.zip的包,然后覆盖过去就OK了,其实里面就三个包文件,一个是bin下面的jmx.jar,一个是common\endorsed\xercesImpl.jar和common\endorsed\xml-apis.jar,一共是三个文件而已   http://jakarta.apache.org/site/downloads/index.html

CASE用法

http://cindysaj.iteye.com/blog/296635   SELECT col1, col2,        CASE           WHEN col3 > 1 AND col3 <2              THEN '1'           WHEN col3 > 2 AND col3 <3              THEN '2'           WHEN col3 > 3 AND col3 <4              THEN '3'           ELSE '4'        END myleve ...
http://www.cnblogs.com/ldaqiang/articles/1212839.html
1在oracle的数据库里有个函数 LPAD(String a,int length,String addString).               2作用:把addString添加到a的左边,length 是返回值的长度。                3例子                   A : SQL> select lpad('test',8,0) from dual;                 LPAD('TEST',8,0)                     ----------------                  0000test         ...

toUnicode

    博客分类:
  • JAVA
//特殊字符转UNICODEpublic static String toUnicode(String theString, boolean escapeSpace) {        int len = theString.length();        int bufLen = len * 2;        if (bufLen < 0) {            bufLen = Integer.MAX_VALUE;        }        StringBuff ...

fromUnicode

    博客分类:
  • JAVA
/**     * 从 Unicode 码转换成编码前的特殊字符串。     * @param in Unicode编码的字符数组。     * @param off 转换的起始偏移量。     * @param len 转换的字符长度。     * @param convtBuf 转换的缓存字符数组。     * @return 完成转换,返回编码前的特殊字符串。     */ public static String fromUnicode(char[] in, int off, int len, char[] convtBuf) {        if (convtBuf.length & ...
Global site tag (gtag.js) - Google Analytics