CREATE OR REPLACE PROCEDURE S_Insert
(SID IN NUMBER,SN IN varchar2 ,SA IN SMALLINT,
SE IN CHAR ,SD IN varchar2
AS
BEGIN
INSERT INTO S
VALUES(SID,SN,SA,SE,SD)
END S_Insert;
(SID IN NUMBER,SN IN varchar2 ,SA IN SMALLINT,
SE IN CHAR ,SD IN varchar2
AS
BEGIN
INSERT INTO S
VALUES(SID,SN,SA,SE,SD)
END S_Insert;
解决方案 »
- 数据库文件验证失败怎么解决
- EBS库存模块中的shortage parameter是用来干什么的啊
- 求一个sql语句的些法
- 一条oracle 中的sql语句?
- oracle 怎么向long数据类型的字段插入数据
- 请问条行列合并的sql该怎么写
- 问题:为何出现警告,如何查看出现的警告,如何解决?
- 调试中出项错误信息是 sqlca.sqlcode 的值为 '-1' 请问该怎么解决???
- 有关svrmgrl的问题,急
- 如何用oracle定时创建表和拷贝数据?
- 不用alter table add constraint能给约束起自己的名字吗?
- 在SQL SERVER 中如何取得ORACLE数据库中所有表的名称
CREATE OR REPLACE PROCEDURE S_Insert
(SID IN NUMBER,SN IN varchar2 ,SA IN SMALLINT,
SE IN CHAR ,SD IN varchar2
AS
BEGIN
INSERT INTO S
VALUES(SID,SN,SA,SE,SD);
END S_Insert;
(SID IN NUMBER,SN IN varchar2 ,SA IN SMALLINT,
SE IN CHAR ,SD IN varchar2)
AS
BEGIN
INSERT INTO S
VALUES(SID,SN,SA,SE,SD);
END S_Insert;
(SID IN NUMBER,SN IN varchar2 ,SA IN SMALLINT,
SE IN CHAR ,SD IN varchar2)
AS
BEGIN
INSERT INTO S
VALUES(SID,SN,SA,SE,SD);
END S_Insert;