精确提取返回超过请求的行数 [英] exact fetch returns more than requested number of rows

问题描述

create or replace procedure ref_div
(
  pr_div_id OUT divisions.div_id%type,
  pr_divisions OUT divisions.divisions%type
)
IS
begin
  select div_id,
    divisions
  into 
    pr_div_id,
    pr_divisions
  from divisions;
end;

推荐答案

这不是确切的提取 - 它是一个没有WHILE子句的SELECT，所以它返回表中的所有行。



如果那不是你想要的，那么你需要决定什么条件会将行减少到你想要的行，并作为WHILE子句来限制它。

That isn't an "exact fetch" - it's a SELECT that doesn't have a WHILE clause, so it returns all the rows in the table.

If that isn't what you wanted, then you need to decide what condition will reduce the rows to the ones you want only, and as a WHILE clause to restrict it.

这篇关于精确提取返回超过请求的行数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！