Oracle Database Discussions

Hi everybody

I need to create one script with three alters and PLSQL block:

Here is my original SQL:

alter table ProjectVersionTab add (AdditionalInfo2 varchar2(4000));

DECLARE
CURSOR c_version
IS
SELECT projectversionid, additionalinfo FROM ProjectVersionTab;
BEGIN
FOR version_rec IN c_version
LOOP
UPDATE ProjectVersionTab
SET additionalinfo2 = version_rec.additionalinfo
WHERE projectversionid = version_rec.projectversionid;
END LOOP;
END;

alter table ProjectVersionTab drop column AdditionalInfo;
alter table ProjectVersionTab rename column AdditionalInfo2 to AdditionalInfo;

But when I run it I got following error in Oracle SQl developer:
RA-06550: line 14, column 1:
PLS-00103: Encountered the symbol "ALTER"
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:


Can somebody help me how to do it? I preffer one script file.

thanks