Title: RE: last column in a table is added with a DEFAULT
David,
I haven't yet encountered this specific case, but I doubt that very much.
in my test case with or without, it invalidated to package
body.
It is impossible to add a NOT NULL column that *doesn't* have a DEFAULT to a table
(unless the table is empty). The error you get is "ORA-01758: table must be empty to
add mandatory (NOT NULL) column".
But that's a logical problem, not a bug. Is there any chance the dev is confusing
this prob
Title: RE: last column in a table is added with a DEFAULT
See the test
below:
[EMAIL PROTECTED]> create table t1 (c1
number); Table created. [EMAIL PROTECTED]> insert into t1 (c1)
values (1); 1 row created. [EMAIL PROTECTED]> insert into t1 (c1)
values (2); 1 row created.
Title: RE: last column in a table is added with a DEFAULT
I
understand that part. What the programmer is saying that you can not add
the last column to a table with a default value. Does that sound
reasonable?
thanks, Raj.
David.
-Original Message-From: Jamadagni, Rajendra
t; Subject: RE: last column in a table is
added with a DEFAULT
Sent by:
Title: RE: last column in a table is added with a DEFAULT
David,
The
best way to see if this works is to create a test table. populate it with
some data. Add a column with a default value.
and
observer what happens.
best
way to learn.
Tom Mercadante Oracle Certified Professional
Title: RE: last column in a table is added with a DEFAULT
David,
Nope. Your programmer is wrong.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Ehresmann, David
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 3:09
PMTo: Multiple recipients
Title: RE: last column in a table is added with a DEFAULT
as soon as you add a column all depending code goes invalid, the dependency checking process doesn't discriminate about the default value.
Raj
Raj