Question

我写了一个简单的程序。我试图储存甄选结果会变。我使用“SlectT INTO”查询,但我无法这样做。

例:

DECLARE
     v_employeeRecord  employee%ROWTYPE;
BEGIN
 SELECT * INTO v_employeeRecord
      FROM Employee WHERE Salary > 10;
END;

Answer 1

你有两种选择。你们可以把这个问题变成一个 cur子:

DECLARE
     CURSOR v_employeeRecords IS
          SELECT * FROM Employee WHERE Salary > 10;
     v_employeeRecord  employee%ROWTYPE;
BEGIN
     FOR v_employeeRecord IN v_employeeRecords LOOP
          /* Do something with v_employeeRecord */
     END LOOP;
END;

或者,你可以创建<代码>TABLE。变量:

DECLARE
     v_employeeRecord  employee%ROWTYPE;
     v_employeeRecords IS TABLE OF employee%ROWTYPE;
     i BINARY_INTEGER;
BEGIN
 SELECT * BULK COLLECT INTO v_employeeRecords
      FROM Employee WHERE Salary > 10;

 i := v_employeeRecords.FIRST;
 WHILE v_employeeRecords.EXISTS(i) LOOP
     v_employeeRecord := v_employeeRecords(i);
     /* Do something with v_employeeRecord */
     i := v_employeeRecords.NEXT(i);
 END;
END;

我没有在Oracle尝试过这些样本,因此你可能会发现编辑错误。

Answer 2

您的当选连任一次以上,你们赢得了一定能力,能够利用选举考试委员会。

你们将需要通过成果套建造一条通道:

这表明你将如何使用清晰的治疗器和大体收集 lo。我将表明你如何能够建设最简单的通道(简单治疗器,不需要一个DECLARE部分):

BEGIN
   FOR c_emp IN (SELECT * 
                   FROM Employee 
                  WHERE Salary > 10) LOOP
      /* do something with each row, for example:*/
      UPDATE foo SET bar = bar + c_emp.salary WHERE id = c_emp.id;
   END LOOP;
END;

友情链接