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.
[EMAIL PROTECTED]
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
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.
Raj
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
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
I know, with earlier version of Oracle, columns likely to have null values
were placed at the end of the table, to save on some minuscle bytes of
space. If the null columns fall between columns with data values, then one
byte is used for their storage. Else, they require no storage. But no,
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
Rajendra
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 of