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
- 8144 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
Describe varray?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Explain the use of constraints option in exp command.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Explain table?
What privilege is needed for a user to create indexes in oracle?
What is a snapshot in oracle database?
State any two functions of oracle?
How to rollback the current transaction in oracle?
What is oracle data type?
What is a sub query? Describe its types?
How does oracle handle read consistency?
What exactly do quotation marks around the table name do?
How to call a stored function with parameters?
How does Oracle guarantee data integrity of data changes?
