Question

oracle生成insert语句的存储过程怎么写

Answer 1

参考代码：
包stuPack添加代码如下：
PROCEDURE usp_InsertStudent (
vage NUMBER,vstuName VARCHAR2);
包stuPack的程序包主体添加代码如下
PROCEDURE usp_InsertStudent (
vage NUMBER,vstuName VARCHAR2) As
BEGIN
INSERTINTOSTUDENT(stuName,age)
VALUES(vstuName,vage);
END;
主键自增方案：
create sequencestuSeq;

CREATEORREPLACETRIGGER stu_TRG
BEFOREINSERTORUPDATEOF stuID
ON Student
FOREACHROW
BEGIN
IF INSERTING THEN
SELECT stuSeq.NEXTVAL INTO :NEW.stuID FROM DUAL;
ELSE
RAISE_APPLICATION_ERROR(-20020, '不允许更新stuID值！');
ENDIF;