Answer Posted / vipin kumar ( m.c.a)
Cursor is a private SQL work area to perform an action using
PL/SQL statement. DBA allocate the memory space to the
objects that is area is called the cursor.
Cursor has two types-
1. Implicit cursor:- means predefine cursor.
2. Explicit cursor:- means created by the user or programmer.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain mutating triggers.
Difference between hot backup vs. Cold backup?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is a connect identifier?
What is meant by raw datatype?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What privilege is needed for a user to create views in oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to define an external table with a text file?
How to manage transaction isolation level?
What is ADDM Advisor in Oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What do you know about normalization? Explain in detail?
What are the attributes that are found in a cursor?
What happens to the current transaction if the session is killed?