Re: Not Null Column in a existing table....
From: Jason Judge <jason.judge_at_virgin.net>
Date: Mon, 18 Oct 1999 22:39:48 +0100
Message-ID: <7ug3f3$ie$1_at_nclient15-gui.server.virgin.net>
Date: Mon, 18 Oct 1999 22:39:48 +0100
Message-ID: <7ug3f3$ie$1_at_nclient15-gui.server.virgin.net>
In Oracle 8 you can add a NOT NULL column with a default value in one go. The new column will then be pre-populated with the default value. This is a feature I have found very useful.
I don't think this will work in Oracle 7 though.
JJ Received on Mon Oct 18 1999 - 23:39:48 CEST