Explain the usage of WHERE CURRENT OF clause in cursors ?
Answer Posted / rahul koshti
By using WHERE CURRENT OF clause you can update or delete
records from the table where CURSOR fetched the records. But
for this you MUST have to open cursor with the clause of
'FOR UPDATE [OF COLUMN_NAME]'.
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Inline the values in PL/SQL, what does it mean.?
What is the purpose of a sql?
What are sql procedures?
where are cookies actually stored on the hard disk? : Sql dba
What is materialized view. What are different methods of refresh?
What is latest version of sql?
What is server name sql?
Does sql*plus have a pl/sql engine?
Write a unique difference between a function and a stored procedure.
Is inner join same as self join?
What are the basic techniques of indexing?
How to rename a column in the output of sql query?
How do I write a sql query in pgadmin 4?
how to drop an existing view in mysql? : Sql dba
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql