MariaDB / MySql vs oracle sql
구분 오라클 MYSQL/MariaDB 현재날짜 SYSDATE SYSDATE() 날짜차이 SYSDATE - A.PWSETDATE DATEDIFF(SYSDATE,A.PWSETDATE) CONCAT LPAD(D.ORDNO,5,'0')||LPAD(C.ORDNO,5,'0')||LPAD(B.ORDNO,5,'0')||LPAD(A.ORDNO,5,'0') CONCAT(LPAD(D.ORDNO,5,'0'),LPAD(C.ORDNO,5,'0'),LPAD(B.ORDNO,5,'0'),LPAD(A.ORDNO,5,'0')) 앞3자리 SUBSTR(A.PROGRAMCD,0,3) LEFT(A.PROGRAMCD,3) 그룹함수 LISTAGG(B.MENUNAME, ' > ') WITHIN GROUP(ORDER BY B.MENUCD) GROUP_..
2023. 4. 4.
