oracle生成guid

最新推荐文章于 2024-04-18 16:17:49 发布

dadou2007

最新推荐文章于 2024-04-18 16:17:49 发布

阅读量1.5k

点赞数

文章标签： oracle function

本文链接：https://blog.csdn.net/dadou2007/article/details/1800133

版权

CREATE OR REPLACE FUNCTION AILDM_GET_GUID
    RETURN CHAR
IS
   v_guid               CHAR ( 36 );
   v_guid_part_one      CHAR ( 8 );
   v_guid_part_two      CHAR ( 4 );
   v_guid_part_three    CHAR ( 4 );
   v_guid_part_four     CHAR ( 4 );
   v_guid_part_five     CHAR ( 12 );
BEGIN
    SELECT SYS_GUID ()
      INTO v_guid
      FROM DUAL;

   v_guid_part_one : = SUBSTR (v_guid, 0 , 8 );
   v_guid_part_two : = SUBSTR (v_guid, 8 , 4 );
   v_guid_part_three : = SUBSTR (v_guid, 12 , 4 );
   v_guid_part_four : = SUBSTR (v_guid, 16 , 4 );
   v_guid_part_five : = SUBSTR (v_guid, 20 , 12 );
   v_guid : =
      CONCAT
         (CONCAT
             (CONCAT
                 (CONCAT (CONCAT (CONCAT (CONCAT (CONCAT (v_guid_part_one,
                                                           ' - ' ),
                                                  v_guid_part_two
                                                 ),
                                           ' - '
                                         ),
                                  v_guid_part_three
                                 ),
                           ' - '
                         ),
                  v_guid_part_four
                 ),
               ' - '
             ),
          v_guid_part_five
         );
    RETURN (v_guid);
END AILDM_GET_GUID;