Using Explicit Cursors  «Prev 

Define cursor in PL/SQL

CURSOR <cursor_name> [([parameter_1 [,parameter_2])]
  [RETURN return_specification] is
    SELECT <select_clause>;
---------------------------------------
CURSOR pets is 
  SELECT PRODUCT_NAME, CURRENT_INVENTORY_COUNT
    FROM PRODUCT WHERE PRODUCT_NAME LIST 'Fish%';

Oracle PL/SQL Programming
CURSOR <cursor_name> Name of thecursor
[RETURN return_specification] Optional return clause for the cursor
select_clause: A valid SQL SELECT statement
pets : Name of the cursor

SELECT PRODUCT_NAME, CURRENT_INVENTORY_COUNT
FROM PRODUCT WHERE PRODUCT_NAME LIKE 'Fish%'
A valid SQL SELECT statement