Re: Appending columns

david j skiba (skiba_at_cis.ohio-state.edu) wrote:
: 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?

try:
ALTER TABLE egtable
ADD ( egcolumn NUMBER(14,2) NULL )

For adding mandatory columns do above, then populate the column, then ALTER the column to be NOT NULL.

--
Steve Corbett.                    vvv
                                 [. .]   "just one person's opinion"
p0070623_at_brookes.ac.uk -------o00-(_)-00o---------