Answer Posted / amit basu
Types of Cursor :
I) Implicit
II) Explicit (Explicit cursor has three sub-types)
1) Simple Cursor
2) Parameterised Cursor
3) Reference Cursor
EXPLANATION OF
I) Implicit--- SINGLE USER ONLY
II) Explicit ----- MULTI USER ONLY
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to delete a column in an existing table?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is a nested table and how is it different from a normal table?
Differentiate between pre-select and pre-query?
What is key preserved table?
What are the different windows events activated at runtime ?
Explain an integrity constrains?
What are joins, explain all types of joins?
How to find the duplicate rows count from employees table in oracle?
What is oracle analytical function?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How do we display rows from the table without duplicates?
Explain about the analyze command in oracle?
How view is different from a table?
How to view the data files in the current database?