PL/SQL学习笔记-变量作用域及数据类型深入

DECLARE
current_block VARCHAR2(10) := 'Outer';
outer_block VARCHAR2(10) := 'Outer';
BEGIN
dbms_output.put_line('[current_block]['||current_block||']');
  DECLARE
  current_block VARCHAR2(10) := 'Inner';
  BEGIN
  dbms_output.put_line('[current_block]['||current_block||']');
  dbms_output.put_line('[outer_block]['||outer_block||']');
  END;
dbms_output.put_line('[current_block]['||current_block||']');
END;

[current_block][Outer]
[current_block][Inner]
[outer_block][Outer]
[current_block][Outer]

declare mytitle labor.xland.title%type;
begin
select title into mytitle from labor.xland where state = 0;
dbms_output.put_line(mytitle);
end;

declare 
  myrow labor.xland%rowtype;
begin
select * into myrow from labor.xland where state = 0;
dbms_output.put_line(myrow.title);
dbms_output.put_line(to_char(myrow.state));
end;

declare
  type myrecordtype is record
  (
       mytitle labor.xland.title%type,
       mystate labor.xland.state%type
  );
  myrecord myrecordtype;
begin
select title, state into myrecord from labor.xland;
dbms_output.put_line(myrecord.mytitle);
dbms_output.put_line(to_char(myrecord.mystate));
end;