I want to add some columns to a existing tables through a shell script.
Please help.
echo "
ALTER TABLE MYTABLE <your changes go here................>;
EXIT
" | sqlplus -s username/password@dbname
if the database is DB2 ,then will it work
connect to DB2;
Alter table my_table( my changes .......)