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

Explain the usage of WHERE CURRENT OF clause in cursors ?

Question Posted / tulsi

Answer Posted / tulsi

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

Is This Answer Correct ?

19 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Is a view faster than a stored procedure?

1012

Can we use loop in sql?

1010

What are the different type of joins in sql?

998

What is pragma in sql?

1127

How many sql statements are used?

1072

What are the different datatypes available in PL/SQL?

1147

What is trigger price?

1048

How can I change database name in sql?

1157

When you have to use a default "rollback to" savepoint of plvlog?

1251

What is trigger in flip flop?

1063

Explain the purpose of %type and %rowtype data types with the example?

1047

What are inner and outer joins examples of both?

1009

Are pl sql variables case sensitive?

1092

Why do we use procedures in sql?

1141

What do you mean by dbms? What are its different types?

1065