oracle-function做了个自动生成id.doc

文档介绍：oracle-function做了个自动生成id
CREATE OR REPLACE FUNCTION FUNC_GET_ID RETURN NUMBER IS
O_ID NUMBER(16); V_RANDOM VARCHAR(10);
V_TIME VARCHAR(20);
BEGIN
--取出2位随机数字
SELECT TRUNC((0, 100)) INTO V_RANDOM FROM DUAL;
--不够2位补齐
IF LENGTH(V_RANDOM) = 1 THEN
V_RANDOM := V_RANDOM || '0';
END IF;
--取出当前日期
SELECT TO_CHAR(SYSDATE, 'YYYYMMDDHHMISS') INTO V_TIME FROM DUAL;
--生成id
O_ID := V_TIME || V_RANDOM;
RETURN O_ID;
END;