Oracle cursor

[anishkannan]

How check cursor have the row data .

[Wendelius]

Hi, you can use cursor%FOUND to see if the cursor has a row but better yet you can define a for loop for a SQL statement. For example:

for MyList in (SELECT Name FROM Emp) loop
...
end loop;

The need to optimize rises from a bad design.My articles[^]