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
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is bulk copy or bcp in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How do we create privileges in oracle?
What is a snapshot in oracle database?
How can windows applications connect to oracle servers?
Write a trigger example in oracle?
Explain the use of inctype option in exp command.
How many types of synonyms in Oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to see the table columns used in an index?
What is an oracle function?
What is a lookup table in oracle?
How do I reset a sequence in oracle?
Will you be able to store pictures in the database?explain.