Re: Example of using ALTER to add columns

Have your tried
Going into sqlplus and entering

        help alter table

The command is
alter table table_name_here add
( new_col1 datatype,
  new_col2 datatype
)

Michael Duke (a10377_at_email.mot.com) wrote:

: Could anyone show me an example of using ALTER to add
: columns to a table? Is it as simple as
 

: ALTER TABLE tablename
: rowname rowtype,
: rowname rowtype;
 

: Thanks in advance,
: Michael
: a10377_at_email.mot.com

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.