Hi,
Yesterday i was conducting an interview and was asking questions related to cursor. I asked the candidate to explain about Implicit cursor.
He gave me an example like this.
for i in 1..10
loop
...
end loop;
At a first look it felt he was wrong. Because oracle creates a Cursor only for SQL statements. But then after the interview i started to think how oracle processes this? How is 1..10 is processed. What memory does it use?
Not sure if this is a silly question ;)