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
- 8169 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 do I recompile a procedure in oracle?
What are the limitations of check constraint?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How data locks are respected in oracle?
Can multiple cursors being opened at the same time?
How to write a query with an inner join in oracle?
What is a partition in oracle?
What is define in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
what is the dual table in oracle?
Explain user account with reference to oracle.
What are the predefined tablespaces in a database?
What exactly do quotation marks around the table name do?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what is insert all statement in sql
