Oracle bulk into clause

• 例子

DECLARE
  TYPE salaryTab IS TABLE OF plch_employees.salary%TYPE;
  s_tab salaryTab;
  TYPE eTab IS RECORD (
    last_name plch_employees.last_name%TYPE,salary  plch_employees.salary%TYPE
  );
  TYPE eTab1 IS TABLE OF eTab;
  e_tab eTab1;
BEGIN --fetch single col with bulk collect clause SELECT salary BULK COLLECT INTO s_tab FROM plch_employees;
  FOR i IN 1..s_tab.count
  LOOP
    dbms_output.put_line('fetch data by bulk: ' || s_tab(i));
  END LOOP;
  --fetch single col with for clause
  FOR eachrow IN (SELECT salary FROM plch_employees) LOOP dbms_output.put_line('fetch data by for: ' || eachrow.salary);
  END LOOP;
  --fetch multiple cols with bulk collect clause
  SELECT last_name,salary BULK COLLECT INTO e_tab FROM plch_employees;
  FOR i IN 1..e_tab.count
  LOOP
    dbms_output.put_line('fetch data by bulk: ' || e_tab(i).last_name || ' ' || e_tab(i).salary);
  END LOOP;
  --fetch multiple cols with for clause
  FOR eachrow IN (SELECT last_name,salary FROM plch_employees) LOOP dbms_output.put_line('fetch data by for: ' || eachrow.last_name || ' ' || eachrow.salary);
  END LOOP;
END;
/

class A {
    private String A;
    public String B;
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!