---创建表
create table TESTTABLE
(
id1 VARCHAR2(12),
name VARCHAR2(32)
)
select t.id1,t.name from TESTTABLE t
begin
insert into TESTTABLE (ID1, NAME) values ('1', 'zhangsan');
insert into TESTTABLE (ID1, NAME) values ('2', 'lisi');
insert into TESTTABLE (ID1, NAME) values ('3', 'wangwu');
insert into TESTTABLE (ID1, NAME) values ('4', 'xiaoliu');
insert into TESTTABLE (ID1, NAME) values ('5', 'laowu');
commit;
end;
---创建存储过程
create or replace procedure test_count as
v_total number(1);
begin
select count(*) into v_total from TESTTABLE;
DBMS_OUTPUT.put_line('总人数:' || v_total);
end;
---去命令下执行
EXECUTE test_count;
----在ql/spl中的sql中执行
begin
-- Call the procedure
test_count;
end;
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)