Re: UPDATE COMMAND

You have two choices here:

(1) Write an update statement with associated select statements like:

update employee e set e.salary = (select s.salary from sal s where s.emp = e.emp);

(2) Write a PL/SQL script that contains a "cursor loop" to do very
detailed processing.

Rock.
Oak Ridge, TN. USA.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!