javascript中创建的对象引用自定义样式表obj.className="自定义的样式表名称"
javascript 中遍历map for(var key in map)
acegi 用户登录成功后记录用户登录日志 http://java.csdn.net/page/f04d066b-e4cc-41ce-b592-5f60ae539c90#
orcale取指定时间范围的月份列表
select distinct to_char(t.dt,'yyyy-mm') as p_month
from (select to_date( '2009-01',' yyyy-mm' ) + rownum - 1 as dt
from user_objects
where rownum <= to_date('2009-03','yyyy-mm')-to_date('2009-01','yyyy-mm')) t
order by p_month
select to_date( ' 2007/02/26 ' , ' yyyy/mm/dd ' ) + rownum - 1 from user_objects where rownum <= (to_date( ' 2007/03/21 ' , ' yyyy/mm/dd ' ) - to_date( ' 2007/02/26 ' , ' yyyy/mm/dd ' ) + 1 );
select distinct to_char(t.dt, 'yyyy-mm-dd') as p_time
from (select To_Date('2008-01', 'yyyy-mm') + (level - 1) dt
from Dual
connect by Trunc(To_Date('2008', 'yyyy')) + level - 1 <=
Trunc(To_Date('2010', 'yyyy'))) t
order by p_time desc
使用WMSYS.WM_CONCAT函数实现行列转换select jmjkdabzj,WMSYS.WM_CONCAT(mbzldm)dm from jmshmb group by jmjkdabzj
分组加序号:
序号会出现跳 号。如1,2,2,4,5
2.dense_rank() over()
序号不会出现跳 号。如1,2,2,3,4
3.row_number() over()
不会出现相同顺序 号。如1,2,3,4,5