首页 > 代码库 > PL/SQL学习

PL/SQL学习

资料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;