MySQL、Oracle、DM、PG、SQLServer、DB2创建Function对象的测试脚本

MySQL

CREATE FUNCTION get_full_name(first_name VARCHAR(50), last_name VARCHAR(50))
RETURNS VARCHAR(100)
DETERMINISTIC
BEGIN
    RETURN CONCAT(first_name, ' ', last_name);
END;

Oracle

CREATE OR REPLACE FUNCTION get_full_name(first_name VARCHAR2, last_name VARCHAR2)
RETURN VARCHAR2 IS
BEGIN
    RETURN first_name || ' ' || last_name;
END;

DM

CREATE OR REPLACE FUNCTION get_full_name(first_name VARCHAR2, last_name VARCHAR2)
RETURN VARCHAR2 IS
BEGIN
    RETURN first_name || ' ' || last_name;
END;

PG

CREATE OR REPLACE FUNCTION get_full_name(first_name TEXT, last_name TEXT)
RETURNS TEXT AS $$
BEGIN
    RETURN first_name || ' ' || last_name;
END;
$$ LANGUAGE plpgsql;

SQLServer

CREATE FUNCTION get_full_name (@first_name NVARCHAR(50), @last_name NVARCHAR(50))
RETURNS NVARCHAR(100)
AS
BEGIN
    RETURN CONCAT(@first_name, ' ', @last_name);
END;

DB2

CREATE FUNCTION get_full_name(first_name VARCHAR(50), last_name VARCHAR(50))
RETURNS VARCHAR(100)
LANGUAGE SQL
BEGIN
    RETURN first_name || ' ' || last_name;
END