State the difference between implict and explict cursor's?
Answer Posted / swapna
Implicit Cursor are declared and used by the oracle
internally. whereas the explicit cursors are declared and
used by the user.
more over implicitly cursors are no need to declare oracle
creates and process and closes autometically. the explicit
cursor should be declared and closed by the user.
More over Explicit Cursors were used to retrieve values
from two or more rows.
| Is This Answer Correct ? | 28 Yes | 2 No |
Post New Answer View All Answers
Is it possible to link two groups inside a cross products after the cross products group has been created?
Can you inner join the same table?
Why use stored procedures?
When you have to use a default "rollback to" savepoint of plvlog?
how to load data files into tables with 'mysqlimport'? : Sql dba
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is primary key and foreign key?
What is the difference between the sql*loader and import utilities? : aql loader
What is case function?
what is oltp (online transaction processing)? : Sql dba
How to connect a sql*plus session to an oracle server?
How do you truncate?
What is sql profiler in oracle?
What will you get by the cursor attribute sql%notfound?
What is the most important ddl statements in sql are?