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
What are the ddl commands?
what is the difference between group by and order by in sql? : Sql dba
What is snowflake sql?
What is data abstraction in sql?
What are the two parts of design view?
What is normalization sql?
how to use 'mysql' to run sql statements? : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Is sql a backend?
What is use of package in pl sql?
Can you have a foreign key without a primary key?
How to rename a column in the output of sql query?
what is the difference between where clause and having clause? : Sql dba
Explain the difference between triggers and constraints?
what is union? : Sql dba