在Oracle Live SQL中返回50行

Question

关于Oracle Live SQL在线环境（ https://livesql.oracle.com/ ）

：查询，默认情况下仅返回50行。

有没有办法返回50行？

---

示例会话：

---

源脚本： a>

--This query should return 220 rows.
with dimension as (
    select 0 as point from dual
      union all 
    select level
    from dual
    connect by level <= 10
), points as (
    select 
      a.point as startpoint, 
      b.point as endpoint,
      c.point as fixed
    from dimension a
    cross join dimension b
    cross join dimension c
    where b.point - a.point = 1
)
select
  startpoint as startpoint_x,
  fixed as startpoint_y,
  endpoint as endpoint_x,
  fixed as endpoint_y
from points
  union all
select
  fixed as startpoint_x,
  startpoint as startpoint_y,
  fixed as endpoint_x,
  endpoint as endpoint_y
from points
order by startpoint_y, endpoint_y, startpoint_x, endpoint_x

Answer 1

这是livesql的限制。您可以使用选项操作 - ＆gt;最大行首选项 ，您可以在其中设置最高限制5000。AFAIK仍然无法设置Infinity-有一个解释“这可以防止您的浏览器被非常大的查询结果超载。小部件。

Answer 2

DECLARE cur CURSOR FOR
SELECT Salary FROM YourTableName WHERE Salary < @SalaryThreshold;

OPEN cur;

DECLARE @CurrentSalary INT;

FETCH NEXT FROM cur INTO @CurrentSalary;

WHILE @@FETCH_STATUS = 0
BEGIN
    UPDATE YourTableName
    SET Salary = @NewSalary
    WHERE CURRENT OF cur;

    FETCH NEXT FROM cur INTO @CurrentSalary;
END

CLOSE cur;

DEALLOCATE cur;