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

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 / preethi raju

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

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

Please Help Members By Posting Answers For Below Questions

What is a proxy class?

1059

What is the string concatenation operator in oracle?

1178

What are the ways tablespaces can be managed and how do they differ?

2369

Why is oracle so popular?

1000

What are oracle functions?

1033

What is a table index?

1101

What do you understand by database schema and what does it hold?

1231

Explain the use of log option in exp command.

1122

What is the use of oracle?

1030

How to execute a stored program unit?

1079

What is the max number of columns in an oracle table?

1001

How to run the anonymous block again?

1132

How do we get field detail of a table?

1081

Explain user account with reference to oracle.

993

Why is oracle database so popular?

1007