CREATE OR REPLACE PROCEDURE testProcedure AS
BEGIN
insert into test values(1);
COMMIT;
END;test表就是一个TOTAL_NUMBER字段的number类型
BEGIN
insert into test values(1);
COMMIT;
END;test表就是一个TOTAL_NUMBER字段的number类型
调试欢乐多
--没问题啊Connected to:
Oracle Database 10g Release 10.1.0.2.0 - ProductionSQL> DROP TABLE test;Table dropped.SQL> CREATE TABLE test(id number);Table created.SQL>
SQL> CREATE OR REPLACE PROCEDURE testProcedure AS
2 BEGIN
3 insert into test values(1);
4 COMMIT;
5 END;
6 /Procedure created.SQL> EXEC testProcedure;PL/SQL procedure successfully completed.SQL> SELECT * FROM test; ID
----------
1SQL>
scott@YPCOST> create table test(TOTAL_NUMBER number);表已创建。scott@YPCOST> CREATE OR REPLACE PROCEDURE testProcedure AS
2 BEGIN
3 insert into test values(1);
4 COMMIT;
5 END;
6 /过程已创建。scott@YPCOST> exec testProcedure; --你是不是没有调用这个过程啊PL/SQL 过程已成功完成。scott@YPCOST> select * from test;TOTAL_NUMBER
------------
1
已写入 file afiedt.buf 1 BEGIN
2 insert into test values(2);
3 COMMIT;
4* END;
scott@YPCOST> /PL/SQL 过程已成功完成。scott@YPCOST> select * from test;TOTAL_NUMBER
------------
1
2
DROP TABLE test;CREATE TABLE test(id number);
CREATE OR REPLACE PROCEDURE testProcedure AS
BEGIN
insert into test values(1);
COMMIT;
END;
表创建了,插入没成
CREATE OR REPLACE PROCEDURE testProcedure AS
BEGIN
insert into test values(1);
COMMIT;
END;
exec testProcedure;
还是没有记录
CREATE TABLE test(id number);
CREATE OR REPLACE PROCEDURE testProcedure AS
BEGIN
insert into test values(1);
COMMIT;
END;
/
exec testProcedure;
select * from test;