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?
Answer Posted / 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 View All Answers
What is Redo Log Buffer in Oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is a trace file and how is it created in oracle?
How do I connect to oracle?
What's dateware house and what's clustor with practicle example
How to name query output columns in oracle?
What is a read write transaction in oracle?
How to use "if" statements on multiple conditions?
How to use attributes of the implicit cursor in oracle?
How to use "while" statements in oracle?
Explain what are the uses of rollback segment?
What do you mean by merge in oracle and how can you merge two tables?
Explain the difference between a procedure and a function?
What is oracle server autotrace in oracle?
Explain parameter file in oracle.