orcale 常见用法

1、查找单个字段

select 字段名,count(*) from table group by 字段名 having count(*) > 1

2、查找组合字段：

SELECT TEST_NAME1,TEST_NAME2,COUNT(*) FROM table GROUP BY TEST_NAME1,TEST_NAME2 HAVING COUNT(*) > 1

3.sqlserve 函数转换成 oracle 的函数
CONVERT(VARCHAR(20),null) 替换成
(SELECT CAST(null AS VARCHAR(20)) as result from dual)

CAST (NULL AS VARCHAR(150)) 替换成
(SELECT CAST(null AS VARCHAR(150)) as result from dual)

GETDATE()替换成
sysdate

LEFT截取字符串
substr

CONVERT(VARCHAR(20),null) 替换成
(SELECT CAST(null AS VARCHAR(20)) as result from dual)

isnull(字段, 0)
NVL(字段, 0)；//判断字段是否为null,是就返回0

4.导出数据库
expdp eman/eman@orcl schemas=eman dumpfile=expdpexam.dmp directory=eman logfile=expdpeman.log;