--没问题啊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
我把你的sql拷过去用,表创建了,可是数据没插入
--注意命名块(存储过程)和未命名块的区别 已写入 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
还有个问题怎么用plsql跟踪一下sql的执行
我就是在plsql的sql window窗口里输入的 DROP TABLE test;CREATE TABLE test(id number); CREATE OR REPLACE PROCEDURE testProcedure AS BEGIN insert into test values(1); COMMIT; END; 表创建了,插入没成
在执行下这个语句exec testProcedure;
DROP TABLE test;CREATE TABLE test(id number); CREATE OR REPLACE PROCEDURE testProcedure AS BEGIN insert into test values(1); COMMIT; END; exec testProcedure; 还是没有记录
DROP TABLE test; CREATE TABLE test(id number); CREATE OR REPLACE PROCEDURE testProcedure AS BEGIN insert into test values(1); COMMIT; END; / exec testProcedure; select * from test;
--没问题啊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;