神之一招

摘要： declare : CURSOR cursor_name ISselect_statement ;open : OPEN cursor_nameif the query returns no rows when the cursor is opened , PL/SQL does not raise an exception . However , you can test thestatus of the cursor after a fetch using the SQL%ROWCOUNT cursor attribute .fetch : FETCH cursor_name INTO [ 阅读全文