ITeye博客

如果有一天

hudingchen · 共 24 篇文章

Oracle中,varchar2 最大长度

1.当表的字段类型是varchar2时,无论是varchar2(4000 char)还是varchar2(4000 byte),最大长都是4000字节。 2.当在plsql中的变量是varchar2时,最大长是32767字节。 3.当func的参数类型是varchar2时,最大长是32767字节。 4.当func的返回值类型是varchar2时,最大长是4000字节。

2015-09-30 09:52 · Oracle · 评论(0)

mongodb csv 导入

mongoimport -d stock_modeling -c t_tick --type csv --file SH#600000.csv --fields stock_code,tick_time,open,high,low,close,volume,turn_volume,restoration_right,exchange

2015-08-27 17:16 · 评论(0)

netty5.0 -- ChannelPipeline

Interface ChannelPipeline public interface ChannelPipeline extends Iterable<Map.Entry<String,ChannelHandler>> A list of ChannelHandlers which handles or intercepts inbound events and outbound operations of a Channel. ChannelPipeline implements an advanced form of the Intercepting Filter pattern to …

2015-07-15 10:50 · Java · 评论(0)

ubuntu 各种安装

jdk : https://www.digitalocean.com/community/tutorials/how-to-install-java-on-ubuntu-with-apt-get mysql: https://help.ubuntu.com/12.04/serverguide/mysql.html mongodb: http://askubuntu.com/questions/147135/how-can-i-uninstall-mongodb-and-reinstall-the-latest-version

2015-05-13 16:46 · 评论(0)

mysql中,分析函数实现的方法

SELECT t2.team, MIN(t2.y) start_hm, MAX(t2.y) end_hm FROM ( SELECT team,y,y - rank y1 from ( SELECT tmp.team, tmp.y, IF(@groupid = tmp.team,@rank := @rank + 1,@rank := 1) AS rank, @groupid := tmp.team FROM (SELECT team,y FROM teamtb ORDER BY y) tmp, (SELECT @rank := 0,@groupid := '') a ) b ) t2 GRO…

2015-01-09 09:42 · 评论(0)

一个SQL的优化

最近看到一个问题(原帖地址:http://topic.csdn.net/u/20120604/09/b56a0996-3c5a-4c35-9423-8b68d1284db6.html) -- 表TB1 START_ID END_ID ---------- ---------- 1 3 4 6 7 9 10 12 13 15 16 18 19 21 22 24 25 27 28 30 -- 表TB2 TID ---------- 1 2 3 31 -- 查询TB2的结果是在TB1的范围中 -- 期望结果: TID ---------- 1 2 3 简单的写法: SELECT t2.tid FR…

2012-06-05 08:55 · Oracle · 评论(0)

Clean Code

//bad private void printGuessStatistics(char candidate, int count) { String number; String verb; String pluralModifier; if (count == 0) { number = "no"; verb = "are"; pluralModifier = "s"; } else if (count == 1) { number = "1"; verb = "is"; pluralModifier = ""; } else { number = Integer.toString(co…

2012-04-06 16:32 · Java · 评论(0)

菜单自动展开(js实现)

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Untitled </title> <script> window.onload = function() { var childs = document.getElementById("container").childNodes; for (var i = 0;i < childs.length;i++) { if (childs[i].tagName == "LI") { addEvent(childs[i]); } }…

2012-02-09 12:47 · JavaScript · 评论(0)

db_file_multiblock_read_count 对cost的影响

db_file_multiblock_read_count = 32 実行計画 ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=35 Card=1 Bytes=13) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'T1' (TABLE) (Cost=35 Card=9872 Bytes=128336) db_file_multiblock_read_count = 16 実行計画 --…

2012-01-29 13:26 · Oracle · 评论(0)

Oracle的行列转换

行转列: 1.列固定的情况,通过max+decode变换。 WITH t AS ( SELECT 1 tid,'A' typeid, 'book1' typename FROM DUAL UNION ALL SELECT 1 tid,'B' typeid, 'apple1' typename FROM DUAL UNION ALL SELECT 1 tid,'C' typeid, 'phone1' typename FROM DUAL UNION ALL SELECT 1 tid,'D' typeid, 'eye1' typename FROM DUAL UNION ALL SELECT 2…

2011-11-08 09:17 · Oracle · 评论(0)

Oracle中,取得表中所有字段都为null的个数

当表的字段个数很多的时候,取得所有字段都是null的个数 字段很少的时候,可以这么写: select count(*) from tb where a is null and b is null ... 字段很多的时候就不是很方便了,下面用动态sql实现。 DECLARE TYPE myref IS REF CURSOR; cur myref; sqlStr VARCHAR2(200); tb_name VARCHAR2(20); TYPE arrays IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER; column_array arrays…

2011-10-12 13:42 · Oracle · 评论(0)

统计相关

-- 需求:求出下表指定日期的每个TYPE_ID的新增客户和累计新增客户, -- 20110703的新增客户=去重(20110703的手机号 MINUS (20110701+20110702的手机号)) -- 20110703累计新增客户 = 去重((20110703+20110702)的手机号 MINUS 20110701的手机号)) SQL> select * from tab; DATE_ID TYPE_ID USER_PHONE -------------------- -------------------- -------------------- 20110701 T恤 134…

2011-07-06 12:54 · Oracle · 评论(0)

Oracle中Keep的使用

官方文档有如下说明: FIRST/LAST Functions The FIRST/LAST aggregate functions allow you to return the result of an aggregate applied over a set of rows that rank as the first or last with respect to a given order specification. FIRST/LAST lets you order on column A but return an result of an aggregate applied…

2011-06-28 13:06 · Oracle · 评论(0)

Oracle中range的使用

-- 需求:求出下表的一个小时内id个数的最大值和最小值。 SQL> WITH t AS ( 2 SELECT 1 "id",TO_DATE('2011-04-27 14:05:12','yyyy-mm-dd hh24:mi:ss') c_time FROM DUAL UNION ALL 3 SELECT 2,TO_DATE('2011-04-27 15:10:42','yyyy-mm-dd hh24:mi:ss') FROM DUAL UNION ALL 4 SELECT 3,TO_DATE('2011-04-27 15:20:52','yyyy-mm-dd hh24:mi:ss') FR…

2011-06-28 10:23 · Oracle · 评论(0)

一条sql求N阶乘

-- 根据公式:log(a)(MN)=log(a)(M)+log(a)(N) SQL> SELECT POWER(10, SUM(LOG(10, LEVEL))) 2 FROM DUAL 3 CONNECT BY LEVEL <= 6; POWER(10,SUM(LOG(10,LEVEL))) ---------------------------- 720

2011-06-27 13:47 · Oracle · 评论(0)