oracle
he20101020
这个作者很懒,什么都没留下…
展开
-
oracle常用函数积累
sysdate为系统日期 dual为虚表 日期函数[重点掌握前四个日期函数] 1.add_months[返回日期加(减)指定月份后(前)的日期] select sysdate S1,add_months(sysdate,10) S2, add_months(sysdate,5) S3 from dual; 2.last_day [返回该月最后一天的日期] sel原创 2013-05-04 22:40:07 · 998 阅读 · 0 评论 -
mybatis3 insert语句获取主键
mysql: <![CDATA[ INSERT INTO CHUKU(customerName,salesMan,publishNo,address,phone,createDate,auditorMan,financeOfficer,warehouse,consignee) VALUES (#{customerName},#{salesMan},#{publishNo原创 2013-10-25 16:32:58 · 3220 阅读 · 2 评论 -
oracle拼接字符串处理,wm_contact函数使用
CREATE OR REPLACE VIEW NEWSOUTER_V ASselect t.ID, t.MAIN_TITLE, t.SUBTITLE, t.LEADSTITLE, t.ORGANIZE, t.IS_OUTER_NEWS, t.OUTER_TYPE, t.OUTR_SUBJECT,原创 2013-12-24 11:37:28 · 15773 阅读 · 0 评论 -
soa部署项目,启动时报错:No credential mapper entry found for password indirection user
soa部署项目一直报错:No credential mapper entry found for password indirection user详细错误信息:weblogic.common.ResourceException: java.security.PrivilegedActionException: weblogic.common.ResourceExcepti原创 2014-05-14 10:09:18 · 3083 阅读 · 0 评论