Interested to Buy Any Domain ? << Click Here >> for more details...
What a SELECT FOR UPDATE cursor represent.?
- 1 Answers
- 2878 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 |
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Describe an oracle table?
What is an anonymous block?
How many types of segments in Oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is the oracle implicit cursor?
what is the syntax of update command?
what is the difference between simple view and complex view?
What are the advantages of Views ?
How to Select second Maximum salary in a Table ?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Oracle General 
