ORACLE中一些常用而且实用的查询和函数

NVL函数：NVL(A,B) 

注解：如果A为空显示B的值，如果A不为空，显示A的值

A为字段名

1.SELECT SUBSTR(A,1,LENGTH(A)-3) A FROM DUAL;

2. SELECT LOWER(A) FROM DUAL;

3.SELECT UPPER(A) FROM DUAL;

4.SELECT REPLACE(A,'-','/') A FROM DUAL;

5.SELECT A||'TEST' A FROM DUAL;

6.SELECT DECODE(A,'0','YES','1','NO','NULL') FROM DUAL