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 / 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
Can select statements be used on views in oracle?
What is query image?
How to shutdown your 10g xe server?
What is PL/SQL ?
What is a initialization parameter file in oracle?
How to display employee records who gets more salary than the average salary in the department?
How to find out what oracle odbc drivers are installed?
Briefly explain what is literal? Give an example where it can be used?
How many types of segments in Oracle?
How can we find out the duplicate values in an oracle table?
Explain the dml?
master table and child table performances and comparisons in Oracle ?
How to create a new view in oracle?
Is oracle an operator?
What is meant by recursive hints in oracle?