Hi All,
I am trying to do a mass updated to all the columns in the below table by using a cursor
& using the sql query mentioned below
But I keep getting an error --> Encountered the symbol "end-of-file" when expecting one of the following: ;
| PERSONID | LASTNAME | FIRSTNAME | ADDRESS | CITY |
|---|
| 11 | Tom B. Erichsen | Skagen 21 | Stavanger | Norway |
| 22 | Joe B. Erichsen | Skagen 21 | Stavanger | minneapolis |
| 33 | Mary B. Erichsen | Skagen 21 | Stavanger | Norway |
QUERY USED
DECLARE
CURSOR Cursor IS SELECT * FROM Persons;
myVar Cursor%ROWTYPE;
BEGIN
OPEN Cursor;
LOOP
FETCH Cursor INTO myVar;
EXIT WHEN Cursor%NOTFOUND;
UPDATE Persons SET LastName='Name:'|| persID WHERE LastName=myVar.LastName and persID=mVar.PersonID ;
END LOOP;
CLOSE Cursor;
END;
My Expected Result is:
| PERSONID | LASTNAME | FIRSTNAME | ADDRESS | CITY |
|---|
| 11 | Name:11 | Skagen 21 | Stavanger | Norway |
| 22 | Name:22 | Skagen 21 | Stavanger | minneapolis |
| 33 | Name:33 | Skagen 21 | Stavanger | Norway |