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
- 8170 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
What is a table index in oracle?
How to drop a stored function?
How to define a sub function?
How to convert a date to char in oracle? Give one example.
How can we find out the duplicate values in an oracle table?
How to define an oracle sub procedure?
Why do we need integrity constraints in a database?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is the usage of synonyms?
How to pass parameters to procedures in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to retrieve values from data fields in record variables?
What is background process in Oracle?
Explain do view contain data?
How to apply filtering criteria at group level in oracle?
