728x90
※ ORACLE 사용방법
  • ex ) SELECT NVL(COLUMN_NM, 0) AS COLUMN FROM DUAL;
 
※ MySQL 사용방법
  • SELECT IFNULL(COLUMN_NM,0) AS COLUMN ;
 
 
728x90
TOP