declare
gids varchar2(50);
begin
select f.gid into gids from d1_familyinfo f where f.shzname='我爱罗';
dbms_output.put_line('gids='||gids);
gids varchar2(50);
begin
select f.gid into gids from d1_familyinfo f where f.shzname='我爱罗';
dbms_output.put_line('gids='||gids);
end;
---------------------上端sql语句可以直接在SQL窗口执行,无需在SQL测试窗口执行,并且end后面的;不能丢------------------