给一个表创建过程并查看该过程信息(是否创建成功)

来源:互联网 发布:驾校坡道数据 编辑:程序博客网 时间:2024/05/29 13:41
<strong>CREATE OR REPLACE PROCEDURE sp_pro7(spBookId IN NUMBER,spbookName IN VARCHAR2,sppublishHouse IN VARCHAR2)IS BEGIN      INSERT INTO  book VALUES(spBookId,spbookName,sppublishHouse); END; SELECT * FROM ALL_SOURCE A WHERE A.name = 'sp_pro7';</strong>

0 0
原创粉丝点击