plsql 匿名块

最近在学plsql，发现和sql一起用，很强大。写的一个匿名块：

declare
  v_num1 number := 1;
  v_num2 number := 2;

  v_string1 varchar2(50) := 'Hello World!';
  v_string2 varchar2(50) := '--This message brought to you by PL/SQL !';
  v_outputStr varchar2(50);

begin 

  insert into temp_table  values(v_num1,v_string1);
  insert into temp_table  values(v_num2,v_string2);

  select CHAR_COL into v_outputStr 
  from temp_table 
  where  num_col = v_num1;

  dbms_output.put_line(v_outputStr);


  select char_col into v_outputStr 
  from temp_table t
  where  t.num_col = v_num2;

  dbms_output.put_line(v_outputStr);


end;

便于以后查阅。