WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the late

Explain the usage of WHERE CURRENT OF clause in cursors ?

Question Posted / swapna

Answer Posted / swapna

WHERE CURRENT OF clause in an UPDATE,DELETE statement
refers to the latest row fetched from a cursor.

Is This Answer Correct ?

10 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the two types of exceptions.

1218

What are system versioned tables?

1074

What types of commands can be executed in sql*plus?

1161

How many postgresql users are there, worldwide?

1128

What is the purpose of cursors in pl/sql?

1200

What is the purpose of my sql?

1010

Which are the different case manipulation functions in sql?

1076

Explain what is sql?

1180

How do I start sql profiler?

1047

What is the clause we need to add in function body to return variable?

1052

How to connect a sql*plus session to an oracle server?

1174

What is aggregate function in sql?

1080

explain commit and rollback in mysql : sql dba

1074

Why do you partition data?

1066

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1132