qq_34169240的博客

Mapper 中参数类型用 Datexml中接受值用TIMESTAMP : #{startTime,jdbcType=TIMESTAMP}注: xml中判断参数是否有值， 只用null就行，千万不能用字符串startTime != '' ,如下： <if test="startTime!= null"> and start_time &gt;= #{startTime,jdbcType...

selectsubstr('1234',0,3)asre如果是pg：得到的结果是12如果是oracle：得到的结果是123如果是mysql：得到的结果是空因为pg和mysql的substr()函数的第一个位置都是为1的，pg为0的时候返回数据是有值的，但mysql为0时候返回数据为空了...

原文链接：https://www.cnblogs.com/jichi/p/11227622.html一张person表，有id和name的两个字段，id是唯一的不允许重复，id相同则认为是重复的记录。select id from group by id having count(*) > 1查找表中多余的重复记录，重复记录是根据单个字段（Id）来判断select*from...

查询结果集中多个字段相同：select *from表awhere(a.Id,a.seq)in(selectId,seqfrom表groupbyId,seqhaving count(*)>1)例子：with res as ( SELECT '1' id, '小明' mc, '15' age from dual union all SE...

1.用jdbc连接：String uName = "sys as sysdba";String uPwd = "Oracle123";String driverName= "oracle.jdbc.driver.OracleDriver";String dbUrl = "jdbc:oracle:thin:@localhost:1521:orcl";  2.用PL/SQL:...

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 。解决方法，使用sqlplus连接上oracle数据库之后，执行命令;select INSTANCE_NAME from v$instance; 然后将显示的结果作为sid name填写到navicat相应的配置文件框内，再...

SELECT  CATEGORY_NAME AS Name,     CASE STATE      WHEN "1" THEN "有效"      WHEN "0" THEN "失效"       END AS "状态"      FROM cc_notification_busi_category ;  

oracle:1.新建需要的用户(用户要有connect resource dba 权限，如图1)、表空间2.cmd导入： imp 用户名/密码@实例名 file=导入的dmp文件路径 full=y [实例名就是SID]mongo:1.新建数据库db_name2.在安装mongo数据库得bin...

1. LISTAGG(RISK_FLAG, ',') WITHIN GROUP (ORDER BY END_TIME,ID) SELECT A.EQUIPMENTCODE,LISTAGG(RISK_FLAG, '') WITHIN GROUP (ORDER BY END_TIME,ID) AS RISK_FLAG_ALL FROM( SELECT...