MySQL Forums
Forum List  »  Oracle

Re: Help with Oracle query.
Posted by: JOSE MARIA STERLING C
Date: May 18, 2006 02:21PM

well, using one CURSOR

DECLARE
CURSOR NAMECURSOR IS
SELECT FIELD1,FIELD2
FROM TABLE1
WHERE CONDITION;
BEGIN
FOR X IN NAMECURSOR LOOP
UPDATE TABLE2 SET FIEL1=X.FIELD2
WHERE FIELD1=X.FIELD1;
COMMIT;
END LOOP;

Options: ReplyQuote


Subject
Views
Written By
Posted
3178
April 12, 2006 12:20PM
2085
April 12, 2006 12:29PM
Re: Help with Oracle query.
2056
May 18, 2006 02:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.