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
- 7943 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / manish kumar
this is not possible we can't create Not Null Constraint in
this column. b'case existing record in column is already
null so oracle through
error: null record found.
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
Is truncate autocommit in oracle?
What is Trigger in Oracle?
What is the difference between primary key and unique key and foreign key in oracle?
What is the difference between sharding and replication?
How to convert csv to table in oracle?
Can we create trigger on materialized view in oracle?
What is oracle latest version?
Explain what are the uses of rollback segment?
Is java required for oracle client?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is bind variable in oracle 11g?
How to add a new column to an existing table with a default value?
Give the different types of rollback segments.
How to create a new view in oracle?
What is oracle sid?
