Using Explicit Cursors  «Prev 

Define cursor in PL/SQL

Define a cursor 
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%';

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
Ad Oracle PL/SQL Programming