Sometimes, we find that a piece of data that we
did not maintain becomes important, and we need to add a new table
column to the database. We can add a table to hold the new data or add
it to our current schema by adding a column to a current table.

For example, we
discover that we need to keep a record of the last date that each
author published and what they published. We need to add two columns
to the author table,
author_last_published (a date) and
author_item_published (a
varchar2(40)). To do this, we use the ALTER TABLE ADD command.

Note:This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.

Verify
experience!Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.

Errata? Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just e-mail:
and include the URL for the page.