Interested to Buy Any Domain ? << Click Here >> for more details...
What a SELECT FOR UPDATE cursor represent.?
- 1 Answers
- 2974 Views
- I also Faced
- E-Mail Answers
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 is meant by joins? List out the types of joins.
How to invoke the data pump import utility?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are transaction isolation levels supported by oracle?
What are the different type of Segments ?
What is a data dictionary and how can it be created?
How to use an explicit cursor without open statements?
What is a data lock in oracle?
how to find the n'th highest salary from emp ?
How to get a list of all user accounts in the database?
how to get count of tables in particular database in Oracle?
Oracle General 
