c# sql语句总结对比(Oracle和SQL)
1.远程库和本地库判断方法
if (m_DbConnection is System.Data.OracleClient.OracleConnection)
2.转日期(DateTime为string类型变量)
oracle:TO_DATE('DateTime', 'yyyy-mm-dd hh24:mi:ss')
sql:#DateTime#
3.日期比较(DateTime为string类型变量)
oracle:B.GXRWSJ >= TO_DATE('DateTime', 'yyyy-mm-dd hh24:mi:ss')
sql:DateDiff(" + "'s'" + $", B.GXRWSJ, #DateTime#) <= 0
关于DateDiff的介绍:(https://www.w3school.com.cn/sql/func_datediff.asp)
4.获取字段长度:
oracle:LENGTH(TCFLDM)
sql:LEN(TCFLDM)
5.日期转string文
oracle:TO_CHAR(GXRWSJ,'yyyymmdd')
sql:FORMAT(GXRWSJ, 'yyyymmdd')
6.截取字符长度
oarcle:SUBSTR(TCFL,1,2)
sql:MID(TCFL,1,2)
7.连接字符串
oracle:CONCAT('1:',BLC)
sql:'1:'&BLC
8.条件语句
oracle:CASE WHEN NVL(A.SCMJ, 0) - NVL(A.PZMJ, 0) > 0 THEN A.SCMJ ELSE A.PZMJ END
sql:'IIF(A.SCMJ IS NULL,0,A.SCMJ)
9.是否为null
oracle: NVL(A.SCMJ, 0)
sql:'SCMJ IS NULL
10.多个字段和一个值比较
oracle: (字段1||字段2||字段3||字段4||字段5) like '%值%'