Single column cursor : Cursor Value « Cursor « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Cursor
  3. Cursor Value

Single column cursor

    

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.








Related examples in the same category

1.Cursor with a single value
2.Update statement with cursor variable
3.Server-side cursor variables.
4.A cursor FOR loop.
5.Cursor Variable Example 2
6.Read full table data from a cursor
7.Use Complex cursor to simplify the pl/sql logic
8.Use cursor to do full table scan
9.Use data referenced by cursor to update table
10.Use number functions when creating a cursor value
11.Form sentences from database data
12.Two identical queries to demonstrate the impact of changes