State the difference between implict and explict cursor's?
- 7 Answers
- 20730 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / nageswara rao orsu
Implicit cursors: used for all DML statements and
single-row queries
Explicit cursors: used for queries of zero, one, or
more rows
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which is the correct statement about truncate and delete?
Why cross join is used?
Which is better cte or subquery?
How do you update a value in sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Explian rowid, rownum? What are the psoducolumns we have?
Is sql harder than python?
How to connect a sql*plus session to an oracle server?
What are the datatypes available in pl/sql ?
Explain scalar functions in sql?
How does cross join work in sql?
What are the ddl commands?
Where not exists in sql?
How do you remove duplicates without using distinct in sql?
Can 2 queries be executed simultaneously in a distributed database system?
