PL/SQL学习

2015-07-24 11:30:07 · 作者: · 浏览: 6

资料1
-- Created on 2014/8/20
declare
-- Local variables here
i integer;
begin
i := 12;
-- Test statements here
DBMS_OUTPUT.put_line(i);
end;

资料2
declare
cursor s is
select * from city_app.city_server;
s_ s%rowtype;
begin
open s;
fetch s into s_;
DBMS_OUTPUT.put_line(s_.id);
close s;
end;