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?
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 are the arithmetic operations?
What is the sql query to concatenate column values from multiple rows in oracle?
How to omit columns with default values in insert statement in oracle?
How to connect to a remote server?
What are the differences between primary key and unique key?
How to experiment a data lock in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to shutdown your 10g xe server from command line?
What is partitioned table in Oracle?
What is coalesce function?
How to rename an existing table?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to write numeric literals in oracle?
What is the difference between I and G in Oracle?
What is define in oracle?