huhu2007的专栏

oracle中，利用nlssort函数，对汉字排序，按拼音顺序排序 [code="java"] order by nlssort(t1.NAME, 'NLS_SORT=SCHINESE_PINYIN_M') [/code]

使用ipc协议连接oracle，前提客户端与oracle server要在一台机器上。 When a process is on the same machine as the server, use the IPC protocol for connectivity instead of TCP. Inner Process Communication on the same mach...

oracle中使用正则匹配一列都是数字，或不是数字 NOT REGEXP_LIKE(description,'[[:digit]]'): Matching for a non-digit [code="java"] SELECT * FROM dual WHERE regexp_like('1234', '^[[:digit:]]+$'); [/code] [code="java"...