Hi Hari,
On Sql prompt write the command
Start <filename>.sql to run all the statements together.

Thanks & Best Regards

Bindu Gupta

-----Original Message-----
From: Hari Bhanujan
[mailto:oracledba-ezmlmshield-x2296617.[Email address protected]
Sent: Friday, September 09, 2005 6:14 AM
To: LazyDBA Discussion
Subject: Running all sql statements together

ALTER TABLE ACCOUNT_NAMEFILE_XREF_N3 ADD new_column number(11,3);
COMMIT;
UPDATE ACCOUNT_NAMEFILE_XREF_N3 SET NEW_COLUMN = SHARE_PERCENT;
COMMIT;
ALTER TABLE ACCOUNT_NAMEFILE_XREF_N3 DROP COLUMN SHARE_PERCENT;
COMMIT;
ALTER TABLE ACCOUNT_NAMEFILE_XREF_N3 RENAME COLUMN NEW_COLUMN TO
SHARE_PERCENT;
COMMIT;

Gurus

What is an easy way to put the four statements above and running it from
one sql file.

If I put ; at the end I am getting 'Invalid Character'

Please help

thanks
Hari


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page