注意事项
1、在创建oracle表时,表名、字段名如果用了“”,则表名、字段名是大小写敏感的;否则表名、字段名都是大写的; 2、存储过程如果有参数,则在存储过程名称后加(参数1,参数2),没有参数则省略(); 参考下列存储过程实例创建存储过程; CREATE OR REPLACE PROCEDURE pr_for_lulu IS
rcount number;
BEGIN
select count(*) into rcount from AATEST where SEQ=119499;
if(rcount>0) then
update AATEST set CCC='1234127' where SEQ =119499;
commit;
Else
insert into AATEST (CCC,SEQ) values ('123121223',119499);
commit;
end if;
exception
when others then
rollback;
END pr_for_lulu;
|
oracle存储过程注意事项
最新推荐文章于 2023-02-24 13:00:34 发布