oracle 转mysql之函数替换

发布时间：2020-12-12 15:20:39 所属栏目：百科来源：网络整理

导读：oracle: CREATE OR REPLACE FUNCTION GET_HTBH RETURN VARCHAR2 IS RESULT VARCHAR2 (14); BEGIN SELECT TO_CHAR (SYSDATE,'yyyy') || TO_CHAR (SYSDATE,'mm') || TO_CHAR (SYSDATE,'dd') || TRIM (TO_CHAR (SEQ_HTBH.NEXTVAL,'000000')) INTO RESULT FROM D

oracle:

CREATE OR REPLACE FUNCTION GET_HTBH

RETURN VARCHAR2
IS
RESULT VARCHAR2 (14);
BEGIN
SELECT TO_CHAR (SYSDATE,'yyyy')
|| TO_CHAR (SYSDATE,'mm')
|| TO_CHAR (SYSDATE,'dd')
|| TRIM (TO_CHAR (SEQ_HTBH.NEXTVAL,'000000'))
INTO RESULT
FROM DUAL;

--select '2006456456' into Result from dual;
--Result := '2006123123';
RETURN (RESULT);

END GET_HTBH;

mysql：

CREATE FUNCTION GET_HTBH()
RETURNS VARCHAR(14)
BEGIN
DECLARE RESULT VARCHAR(14);
select CONCAT((select DATE_FORMAT(NOW(),'%Y%m%d') from dual),LPAD((SEQ_HTBH()),6,'0'))
INTO RESULT
FROM DUAL;
-- select '2006456456' into Result from dual;
-- Result := '2006123123';
RETURN RESULT;
END;

转mysql注意事项 1 过程名要有（） 2 end 不要过程名 3 没as 4DECLARE 要在begin下面 5 return 换成returns

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!