Mega Code Archive

 

Categories / Oracle PLSQL / Cursor

 

Fetch single column cursor to varchar2 variable

SQL> CREATE TABLE products(   2    product_id              NUMBER(6),   3    name            VARCHAR2(50)   4  ); Table created. SQL> SQL> SQL> SQL> declare   2      v_name varchar2(80);   3      cursor get_data is select name from products;   4    begin   5       open get_data;   6       fetch get_data into v_name;   7       dbms_output.put_line(v_name);   8       close get_data;   9  end;  10  / PL/SQL procedure successfully completed. SQL> SQL> SQL> drop table products; Table dropped.