需求:插入一条由Oracle生成UUID的主数据,之后再插入三条子数据,子数据的父ID是主数据的ID。
-- 先定义四个字段,分别是主ID,以及子ID
DECLARE p_id VARCHAR2 ( 50 ) := 10;
m_id1 VARCHAR2 ( 50 ) := 10;
m_id2 VARCHAR2 ( 50 ) := 10;
m_id3 VARCHAR2 ( 50 ) := 10;
-- 为四个ID进行赋值(UUID)
BEGIN
SELECT
sys_guid ( ) INTO p_id
FROM
dual;
SELECT
sys_guid ( ) INTO m_id1
FROM
dual;
SELECT
sys_guid ( ) INTO m_id2
FROM
dual;
SELECT
sys_guid ( ) INTO m_id3
FROM
dual;
INSERT INTO SYS_MENU ( MENU_ID, PARENT_ID, NAME )
VALUES
(
p_id,
'1000',
'车辆管理'
);
INSERT INTO SYS_MENU ( MENU_ID, PARENT_ID, NAME )
VALUES
(
m_id1,
p_id,
'车辆新增'
);
INSERT INTO SYS_MENU ( MENU_ID, PARENT_ID, NAME )
VALUES
(
m_id2,
p_id,
'车辆修改'
);
INSERT INTO SYS_MENU ( MENU_ID, PARENT_ID, NAME )
VALUES
(
m_id3,
p_id,
'车辆删除'
);
END;
如有转载,请随意,
我是来自北京天码科技的卢泽