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
- 7952 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
How to select all columns of all rows from a table in oracle?
Is a rollback possible to any savepoint?
Why do we need integrity constraints in a database?
List out the difference between commit, rollback, and savepoint?
How to increment dates by 1 in oracle?
Can multiple columns be used in group by in oracle?
What is Trigger in Oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is index in Oracle?
What are the original export and import utilities?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to store only time; not date and time?
What are the major difference between truncate and delete?
Describe the types of sub query?
Name the three major set of files on disk that compose a database in Oracle?
