Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 7977 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
candidate key is subset of super key but not vice-verse explain
How to import one table back from a dump file?
What is a synonym? What are its various types?
What are the differences between blob and clob in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
What is transport network substrate (tns) in oracle?
Who developed oracle & when?
what are actual and formal parameters?
What are the execution control statements?
Explain oracle 12c new features for developers?
What is blob data type in oracle?
What is procedure overloading in oracle?
How to start a specific oracle instance?
Can we save images in a database and if yes, how?
Explain an index?
