In my table i have 4 columns with 100 records but in that 4 columns one column

In my table i have 4 columns with 100 records
but in that 4 columns one column contains all NULL values
so can i add NOT NULL CONSTRAINT on that column......... ok
if it is not possible, can i add NOT NULL CONSTRAINT from
101 Record Onwards?

Question Posted / sivanagaraju

4 Answers
6500 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL v..

Answer / manish kumar

this is not possible we can't create Not Null Constraint in
this column. b'case existing record in column is already
null so oracle through
error: null record found.

Is This Answer Correct ?

15 Yes

2 No

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL v..

Answer / sudipta santra

Yes, Krupananda, U r very right..I am explainning the trigger:

Create or replace trigger bri_tab_101_rec
before insert on table1
for each row

declare
usr_ins_excep exception;
begin
if :new.column4 is null then
raise usr_ins_exception;
end if;
exception
when usr_ins_excep
<< do exception code>>
rollback;
end;

Is This Answer Correct ?

4 Yes

0 No

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL v..

Answer / krupananda

It is not possible to add not null constraint on existing
column which contains null values.
but we can add not null constraint from 101 record onwards
using triggers.

using triggers it is possible to restrict not null values

Is This Answer Correct ?

4 Yes

1 No

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL v..

Answer / preethi raju

Yes it is possible by using novalidate with alter table command:

alter table table_name modify(column_with_null constraint constraint_name not null novalidate);

So the novalidate does not check the existing columns which contains the null values.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer