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 |
Explain parameter file in oracle.
What is the difference between 10g OEM and 11g OEM?
How do I spool to a csv formatted file using sqlplus?
how to get second highest sal of emp table
How to use "in" parameter properly?
Tell me New Feature of Oracle 10g?
Explain an index segment?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is forall Statement ?
How to count duplicated values in a column in oracle?
How to use in conditions in oracle?