Output value in cursor one by one

  

SQL> CREATE TABLE products(
  2    product_id              NUMBER(6),
  3    name            VARCHAR2(50)
  4  );

Table created.

SQL>
SQL>
SQL> set serveroutput on
SQL> declare
  2      nameValue varchar2(80);
  3      cursor get_data is select name from products;
  4  begin
  5       for i in get_data
  6       LOOP
  7           dbms_output.put_line(i.name);
  8       END LOOP;
  9  end;
 10  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> drop table products;

Table dropped.

Related examples in the same category

1.	Create a cursor in for statement
2.	The %FOUND, %NOTFOUND, and %ROWCOUNT cursor attributes can be used to guide a loop
3.	A function that uses a CURSOR FOR Loop
4.	Use 'for loop' to loop through the cursor
5.	A subquery in the FROM clause of a cursor within a cursor FOR loop
6.	Assign value from cursor to a table collection by index
7.	Calculation based on cursor value
8.	For each row in a cursor
9.	Simple Loop and fetch cursor
10.	Use pl/sql, cursor and for loop to count table

Output value in cursor one by one : CURSOR FOR Loop « Cursor « Oracle PL / SQL

Related examples in the same category