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 |
What are the built-in functions used for sending Parameters to forms ?
What is bulk copy or bcp in oracle?
What is the difference between normal and corelated subqueries?
How to fetch the row which has the max value for a column?
a query to select maxmun 3 salaries of employee table
How to compare dates in oracle sql?
What is the difference between RBBMS & DBMS?
What privilege is needed for a user to create views in oracle?
why pl sql doesn't support retrieving multiple records
How to see free space of each tablespace?
How to check your oracle database 10g xe installation?
What is difference between truncate and delete?