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
- 8183 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
What is a lookup table in oracle?
What are the numeric comparison operations?
What is oracle open database communication (odbc)?
How to use "if" statements on multiple conditions?
How do I start tns listener?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is the difference between a user and a schema in oracle?
How to delete a column in an existing table in oracle?
How to view the tablespaces in the current database?
How to run the anonymous block again?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How many types of table in Oracle?
What is the difference between a hot backup and a cold backup in oracle?
What is a nvl function?
What are the database administrators utilities available?
