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 advantages of dateset in datastage?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is the relationship among database, tablespace and data file?
Is the After report trigger fired if the report execution fails ?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Can anyone give me information about oracle certification
How to list all user accounts in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is flashback in Oracle?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
how to make an oracle object