SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HELP! pre Oracle 9i UPDATE query

506682Apr 16 2006 — edited Apr 24 2006

Hi, I have a procedure that has this kind of an update query :UPDATE dept d set d.empcount=(SELECT COUNT(*) FROM emptable e WHERE e.deptid=d.depid).

The procedure compiles in Ora9i but not in Ora8.1. Ora8.1 does not allow subqueries on the SET clause.. too bad. =( I have created a cursor based update query that compiles in Ora8.1 but executes slower. Is there anyway of modyfing the update statement without the use of cursors and yet retain its speed just like the update query above?

I hope someone can provide an easy fix for this..=(

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2006

Added on Apr 16 2006

14 comments

4,768 views