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 |
Why required to run root.sh at the time of installation and what exactly it will do
How are the index updates?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to bring a tablespace online?
Please explain joins in oracle?
Explain about achiever in sql?
difference between oracle8i and oracle9i
what is port in oracle? how is it related to database application.
What is oracle join syntax?
Is postgres faster than oracle?
how can we write trigger in trigger???????? can we write one trigger on two table???
what is the exact diiference between DBMS and RDBMS