创建测试表CREATE TABLE mytest(NAME VARCHAR2(30),pwd VARCHAR2(30));
1、存储过程创建
CREATE OR REPLACE PROCEDURE sp_pro1 IS
BEGIN
INSERT INTO mytest VALUES('123','123');
END;
2、调用存储过程
(1) EXEC sp_pro1;
(2) CALL sp_pro1;
创建测试表CREATE TABLE mytest(NAME VARCHAR2(30),pwd VARCHAR2(30));
1、存储过程创建
CREATE OR REPLACE PROCEDURE sp_pro1 IS
BEGIN
INSERT INTO mytest VALUES('123','123');
END;
2、调用存储过程
(1) EXEC sp_pro1;
(2) CALL sp_pro1;
转载于:https://www.cnblogs.com/nuaa/p/3697837.html