Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does Oracle SQLJ support the WHERE CURRENT OF construct?

construct Oracle SQLJ support
0
Posted

Does Oracle SQLJ support the WHERE CURRENT OF construct?

0 CommentsAdd a Comment

1 Answer

0

Not as of release 9.0.1, though possibly in the future. As a workaround, you can explicitly select the ROWID column into your iterator, and then use WHERE ROWID=xxx in place of WHERE CURRENT OF in the UPDATE statement. This workaround would go along the following lines.

0 CommentsAdd a Comment

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.