Difference between OPEN CURSOR..FETCH CURSOR..CLOSE and SELECT...ENDSELECT

Hi,

Can some one please elaborate on the difference between the above ways of getting data. I have gone through the documentation, but it does not directly mention anything about performance differences between them, also please cite the link which can give more detailed info about this conceptually. Most of them show the syntax diagrams only and ways to use the cursor

Thanks

ChK