cursor is nothing but a memory location where the query result are stored, so that you can perform some amthematical operation on the fetched valued, simple select won't let you to perform any operation on the element fetched.So when you perform close cursore , it is nothing but it realses that memory location.So after closing you can't fetch any more records.