State the difference between implict and explict cursor's?
Answer Posted / l..l.n.reddy
IMPLICT CURSOR:- Automatically porvide by oracle which
perform DML statements. queries returns only one row.
EXPLICT CURSOR:- Defined by user. queries returns more
than rows.
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
What is the maximum number of columns in sql table?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Write the alter statement to enable all the triggers on the t.students table.
How will you distinguish a global variable with a local variable in pl/sql?
What is sql partition function?
Which one is better sql or oracle?
What is %type in pl sql?
What is the difference between delete and truncate statement in sql?
How many types of relationship are there?
which types of join is used in sql widely? : Sql dba
What's the difference between a primary key and a clustered index?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What is memory optimized table?
What are % type and % rowtype?
Can instead of triggers be used to fire once for each statement on a view?