Answer Posted / nishi
What a SELECT FOR UPDATE cursor represent. [ANSWER] SELECT......FROM......FOR......UPDATE[OF column-reference][NOWAIT] The processing done in a fetch loop modifies the rows that have been retrieved by the cursor. A convenient way of modifying the rows is done by a method with two parts: the FOR UPDATE clause in the cursor declaration, WHERE CURRENT OF CLAUSE in an UPDATE or declaration statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What are the ways tablespaces can be managed and how do they differ?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Explain user account with reference to oracle.
How to best split csv strings in oracle 9i?
How do I know if oracle client is installed on windows?
What are the different types of database objects?
What are the restrictions in a oracle read only transaction?
what are the default admin accounts in Oracle 10g ?
How can I create database in oracle?
How does one get the view definition of fixed views/tables?
What is raw datatype?
What is the Tune Query
How to get a create statement for an existing table?
What is rich query?
