What a SELECT FOR UPDATE cursor represent.?
Answer / 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 |
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
What are the extensions used by oracle reports?
How can windows applications connect to oracle servers?
How to concatenate two text values in oracle?
Why does oracle 9i treat an empty string as null?
What is an oracle data file?
How to view existing locks on the database?
How to synchronize 2 schema's objects?
What is an oracle database?
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad