在Oracle中的一个ExecuteScalar中运行多个命令

DECLARE
  v_var1 data_type1;
  v_var2 data_type2;
BEGIN
  SELECT column1 INTO v_var1 FROM table1;
  SELECT column2 INTO v_var2 FROM table2;
END;

SELECT column1 FROM table1;
SELECT column2 FROM table2;

SELECT column1 FROM table1
UNION ALL
SELECT column2 FROM table2;