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.