this is not possible we can't create Not Null Constraint in this col

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?

Question Posted / manish kumar

4 Answers
8341 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

Please Help Members By Posting Answers For Below Questions

What is the oracle implicit cursor?

1110

Explain overloading. Can functions be overloaded?

1042

What is difference between sid and service name in oracle?

1006

What is the database name in oracle?

1072

What is the usage of merge statement?

1201

Where are the settings stored for each instance in oracle?

1151

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

what are actual and formal parameters?

1159

How to login to the server without an instance?

1209

Can we save images in a database and if yes, how?

1108

Can we write dml statement in function in oracle?

1121

Does oracle database need java?

1064

What is set operator oracle?

1033

What are the uses of synonyms?

1183

What is columnar storage what is the advantage?

1119