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?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What are the uses of linked server and explain it in detail?
What is partitioned table in Oracle?
What is a system tablespace?
What operating systems are supported by oracle database 10g xe?
what is trigger?
Which are the five query types available in oracle?
What are steps required to ENTER DATA INTO DWH?
Is the After report trigger fired if the report execution fails ?
What is a public synonym?
How to use "if" statements on multiple conditions?
What are the benefits of ordbms?
How can you use check constraints for self referential integrity?