Beginner - Update table

From: Mark Muller <mmu_at_beer.com>
Date: Fri, 6 Dec 2002 09:12:58 +0100
Message-ID: <aspm6a$mvj$1@news.hccnet.nl>

How to write a sql script that whill alter an existing table to a new definition

I have to modify tables, i know what the columns should be, but not what they were (depending on last change at customer site), for example the following table where MOB is a new column. When i try this oracle (9i) is complaining the column ID already is NOT NULL and does not add the MOB column.

ALTER TABLE vaccin.HUISARTS MODIFY (
ID CHAR(10) not null,
NAME CHAR(30) not null,

  TEL CHAR(15) null,
  FAX CHAR(15) null,
  MOB CHAR(15) NULL

); Received on Fri Dec 06 2002 - 02:12:58 CST