17,377
社区成员
发帖
与我相关
我的任务
分享一个很简单的存储过程
create or replace procedure usp_INSERT_order_num()
BEGIN
insert into AA
select * from BB
end usp_INSERT_order_num;
报错第一行少右括号,估计是语法问题
请大家指教
BEGIN
insert into AA
select * from BB
end usp_INSERT_order_num;
报错第一行少右括号,估计是语法问题
请大家指教
...全文
请发表友善的回复…
发表回复
bluesky1980 2007-05-30
- 打赏
- 举报
明白了,谢谢
还应该加上"COMMIT;"
还应该加上"COMMIT;"
hongqi162 2007-05-30
- 打赏
- 举报
create or replace procedure usp_INSERT_order_num()
is
BEGIN
insert into AA
select * from BB;
end usp_INSERT_order_num;
is
BEGIN
insert into AA
select * from BB;
end usp_INSERT_order_num;
