Questionaries.org
Login
Register
Questions
Unanswered
Tags
Users
Ask a Question
Welcome to Questionaries, where you can ask questions and receive answers from other members of the community.
Let us know at info@questionaries.org
What WHERE CURRENT OF clause does in a cursor?
5
like
0
dislike
asked
1 year
ago
by
marck_don
(
191,010
points)
where-current-of
clause
cursor
1 Answer
1
like
0
dislike
Best answer
LOOP
SELECT num_credits INTO v_numcredits FROM classes
WHERE dept=123 and course=101;
UPDATE students
FHKO;;;;;;;;;SET current_credits=current_credits+v_numcredits
WHERE CURRENT OF X;
answered
1 year
ago
by
daneim
(
127,080
points)
Related questions
6
like
0
dislike
1
answer
For which relational operators in where clause, index is not used ?
asked
1 year
ago
by
rad_joshep
(
19,390
points)
relational
operators
clause
index
oracle
7
like
0
dislike
1
answer
What is use of a cursor variable? How it is defined?
asked
1 year
ago
by
DBA-boss
(
120,990
points)
cursor
oracle
variable
5
like
0
dislike
1
answer
What is a package cursor ?
asked
1 year
ago
by
rad_joshep
(
19,390
points)
package
cursor
oracle
5
like
0
dislike
1
answer
What should be the return type for a cursor variable?
asked
1 year
ago
by
marck_don
(
191,010
points)
variable
type
cursor
scalar
5
like
0
dislike
1
answer
What a SELECT FOR UPDATE cursor represent?
asked
1 year
ago
by
daneim
(
127,080
points)
select-for-update
cursor