Oracle System Architecture Question:
Download Job Interview Questions and Answers PDF
What is Cursor in Oracle System Architecture?
Answer:
A cursor can be viewed as a "Pointer" into the result table of an SQL SELECT statement. Cursors are needed whenever the result contains more than one row. 3rd generation programs like COBOL and C cannot handle more than one row at a time. SQL produces a set-at-a-time. The cursor allows the set to be processed one row-at-a-time, just like a sequential file. COBOL and C are happy, SQL is happy. I'm happy.
Download System Architecture Interview Questions And Answers
PDF
Previous Question | Next Question |
Tell me when does LGWR write to the database? | Explain what do Redo Log Buffers contain? |