Dynamic SQL Using OPEN FOR in Oracle PL/SQL

最新推荐文章于 2025-08-15 10:38:51 发布

转载最新推荐文章于 2025-08-15 10:38:51 发布 · 114 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/simonhaninmelbourne/archive/2013/01/23/2872442.html

文章标签：

#数据库 #开发工具

此博客介绍了在Oracle PL/SQL中创建和使用动态游标的示例。示例虽简单，但有助于理解并应用于更复杂的情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

This example illustrates how you can create and use dynamic cursor in Oracle PL/SQL. The example is pretty simple, but I hope you can get the idea and apply it to more complicated cases.

DECLARE
  t_cursor IS REF CURSOR;
  my_cursor t_cursor;
  v_customer RECORD (
     customer_id NUMBER(18),
	 amount NUMBER(22, 2)
  );
BEGIN
  OPEN my_cursor FOR SELECT customer_id, 
                            amount 
                       FROM monthly_sales;
  LOOP
    FETCH my_cursor INTO v_customer;
	EXIT WHEN my_cursor%NOTFOUND;
 
	dbms_output.put_line(v_customer.amount);
  END LOOP;
END;

转载于:https://www.cnblogs.com/simonhaninmelbourne/archive/2013/01/23/2872442.html