Explain the usage of WHERE CURRENT OF clause in cursors ?
Answer Posted / nishi
WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the operators used in select statements?
Describe different types of general function used in sql?
Does sql*plus also have a pl/sql engine?
Why do we need cursor in pl sql?
Is crud a cuss word?
Can we join 3 tables in sql?
Why should I use postgresql?
What is difference between primary and secondary key?
What is the maximum number of rows in sql table?
What is %s in sql?
what is difference between delete and truncate commands? : Sql dba
What is a stored procedure in sql with example?
Why do we use joins in sql?
Define commit, rollback and savepoint?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.