GBase8a数据库bitand函数改写

-- oracle

SELECT BITAND(3,1),BITAND(11,4),BITAND(12,4) FROM DUAL;

-- gbase8a 改写为自定义函数

DELIMITER //

CREATE FUNCTION bitand(num1 decimal(65,0),num2 decimal(65,0)) RETURNS decimal(65,0) BEGIN

DECLARE result decimal(65,0);

select num1&num2 into result;

RETURN result;

END //

DELIMITER ;

SELECT BITAND(3,1),BITAND(11,4),BITAND(12,4) FROM DUAL;