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
- 8358 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
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Explain do view contain data?
What is the data pump export utility?
Explain oracle left join with an example?
How to rename an index?
How to get execution statistics reports on query statements?
What is a tns service name?
What are the varoius components of physical database structure of oracle database?
What are the different types of database objects?
What are transaction isolation levels supported by oracle?
Describe an oracle table?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Explain oracle 12c new features for developers?
What is an Oracle index?
Can we store images in oracle database?
