Re: Appending columns

In article <2kjfj5INNnsa_at_skink.cis.ohio-state.edu> skiba_at_cis.ohio-state.edu (david j skiba) writes:
>I have a table created in an oracle 6 database. Is there an easy way
>to append a new column to the table after data is already in it?
>
>The only way I could think of was to export, delete table, recreate
>new table, import. I am not sure if this will work and was hoping
>for a much easier way...

alter table <table name> add (column1 number, column2 number)

should do the magic.

--
 Alvin W. Law .............................................. Oracle Corporation
 Senior Applications Engineer ..................... 300 Oracle Parkway, Floor 6
 Manufacturing Applications .......................... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ........... Voice: 1.415.506.3390 . Fax: 1.415.506.7299