![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
lvxc0928
为了我的12个粉丝
展开
-
sql/hql对比
1、hql分页String queryString = "from EqpEquipment model " + conditions + " and " + GlobalRoleUtil.getResourceAuthConditions("model.equipcode") + " order by nlssort(equipname,'NLS_SO原创 2014-12-08 15:26:20 · 517 阅读 · 0 评论 -
查询重复记录的SQL语句
select * from log as a ,(select message from log group by message having count(*)>1) bwhere a.message =b.message原创 2014-11-05 16:38:56 · 731 阅读 · 0 评论 -
存储过程、动态sql、for、if
create or replace procedure ---- is COLLECTDATE varchar2(8) := to_char(sysdate-1,'yyyymmdd'); -- 统计日期 yyyymmdd INIT_STATE VARCHAR2(2) ;--当天初始化状态 END_STATE VARCHAR2(2); --当天结束状态原创 2016-01-20 10:40:24 · 743 阅读 · 0 评论 -
clob类型的 映射文件、 bean文件
线路坐标 【bean】private String lineCoordinate;private Clob lineCoordinateClob;public String getLineCoordinate() { //return this.lineCoordinate; //给clob赋值的同时给String赋值 clob原创 2016-01-20 11:23:09 · 1718 阅读 · 0 评论 -
ORA-12704: character set mismatch问题、以及处理wm_concat函数clob乱码问题
在utf8数据库里编译存储过程,遇到这个问题.oracle9206sql: [做了简化]select a from t1union allselect '1' from t2;其中t1.a是nvarchar2类型。解决办法很简单:select a from t1union allselect N'1' from t2;=======================原创 2015-12-25 16:17:20 · 7088 阅读 · 0 评论